Dataset statistics
| Number of variables | 50 |
|---|---|
| Number of observations | 2845342 |
| Missing cells | 3414349 |
| Missing cells (%) | 2.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 838.5 MiB |
| Average record size in memory | 309.0 B |
Variable types
| Categorical | 21 |
|---|---|
| DateTime | 2 |
| Numeric | 13 |
| Boolean | 13 |
| Unsupported | 1 |
Country has constant value "US" | Constant |
Turning_Loop has constant value "False" | Constant |
ID has a high cardinality: 2845342 distinct values | High cardinality |
Description has a high cardinality: 1174563 distinct values | High cardinality |
Street has a high cardinality: 159651 distinct values | High cardinality |
City has a high cardinality: 11681 distinct values | High cardinality |
County has a high cardinality: 1707 distinct values | High cardinality |
Zipcode has a high cardinality: 363085 distinct values | High cardinality |
Airport_Code has a high cardinality: 2004 distinct values | High cardinality |
Weather_Timestamp has a high cardinality: 474214 distinct values | High cardinality |
Weather_Condition has a high cardinality: 127 distinct values | High cardinality |
Start_Lat is highly overall correlated with End_Lat and 1 other fields | High correlation |
Start_Lng is highly overall correlated with End_Lng and 2 other fields | High correlation |
End_Lat is highly overall correlated with Start_Lat and 1 other fields | High correlation |
End_Lng is highly overall correlated with Start_Lng and 2 other fields | High correlation |
Temperature(F) is highly overall correlated with Wind_Chill(F) | High correlation |
Wind_Chill(F) is highly overall correlated with Temperature(F) | High correlation |
State is highly overall correlated with Start_Lat and 4 other fields | High correlation |
Timezone is highly overall correlated with Start_Lng and 2 other fields | High correlation |
Bump is highly overall correlated with Traffic_Calming | High correlation |
Traffic_Calming is highly overall correlated with Bump | High correlation |
Sunrise_Sunset is highly overall correlated with Civil_Twilight and 2 other fields | High correlation |
Civil_Twilight is highly overall correlated with Sunrise_Sunset and 2 other fields | High correlation |
Nautical_Twilight is highly overall correlated with Sunrise_Sunset and 2 other fields | High correlation |
Astronomical_Twilight is highly overall correlated with Sunrise_Sunset and 2 other fields | High correlation |
traffic_event_type is highly overall correlated with traffic_event_type_ext | High correlation |
traffic_event_type_ext is highly overall correlated with traffic_event_type | High correlation |
Severity is highly imbalanced (67.8%) | Imbalance |
Side is highly imbalanced (58.1%) | Imbalance |
Weather_Condition is highly imbalanced (56.4%) | Imbalance |
Amenity is highly imbalanced (92.0%) | Imbalance |
Bump is highly imbalanced (99.5%) | Imbalance |
Crossing is highly imbalanced (63.3%) | Imbalance |
Give_Way is highly imbalanced (97.6%) | Imbalance |
Junction is highly imbalanced (52.4%) | Imbalance |
No_Exit is highly imbalanced (98.4%) | Imbalance |
Railway is highly imbalanced (93.3%) | Imbalance |
Roundabout is highly imbalanced (99.9%) | Imbalance |
Station is highly imbalanced (83.7%) | Imbalance |
Stop is highly imbalanced (87.2%) | Imbalance |
Traffic_Calming is highly imbalanced (99.3%) | Imbalance |
Traffic_Signal is highly imbalanced (55.3%) | Imbalance |
Number has 1743911 (61.3%) missing values | Missing |
Weather_Timestamp has 50736 (1.8%) missing values | Missing |
Temperature(F) has 69274 (2.4%) missing values | Missing |
Wind_Chill(F) has 469643 (16.5%) missing values | Missing |
Humidity(%) has 73092 (2.6%) missing values | Missing |
Pressure(in) has 59200 (2.1%) missing values | Missing |
Visibility(mi) has 70546 (2.5%) missing values | Missing |
Wind_Direction has 73775 (2.6%) missing values | Missing |
Wind_Speed(mph) has 157944 (5.6%) missing values | Missing |
Precipitation(in) has 549458 (19.3%) missing values | Missing |
Weather_Condition has 70636 (2.5%) missing values | Missing |
Number is highly skewed (γ1 = 156.9450181) | Skewed |
Precipitation(in) is highly skewed (γ1 = 106.2589449) | Skewed |
ID is uniformly distributed | Uniform |
ID has unique values | Unique |
date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Distance(mi) has 385441 (13.5%) zeros | Zeros |
Wind_Speed(mph) has 433636 (15.2%) zeros | Zeros |
Precipitation(in) has 2104242 (74.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-03-01 00:02:17.228521 |
|---|---|
| Analysis finished | 2023-03-01 00:09:26.103317 |
| Duration | 7 minutes and 8.87 seconds |
| Software version | pandas-profiling vv3.6.2 |
| Download configuration | config.json |
ID
Categorical
HIGH CARDINALITY UNIFORM UNIQUE
| Distinct | 2845342 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 21.7 MiB |
| A-1 | 1 |
|---|---|
| A-1896898 | 1 |
| A-1896890 | 1 |
| A-1896891 | 1 |
| A-1896892 | 1 |
| Other values (2845337) |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.6095007 |
| Min length | 3 |
Characters and Unicode
| Total characters | 24496974 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2845342 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | A-1 |
|---|---|
| 2nd row | A-2 |
| 3rd row | A-3 |
| 4th row | A-4 |
| 5th row | A-5 |
Common Values
| Value | Count | Frequency (%) |
| A-1 | 1 | < 0.1% |
| A-1896898 | 1 | < 0.1% |
| A-1896890 | 1 | < 0.1% |
| A-1896891 | 1 | < 0.1% |
| A-1896892 | 1 | < 0.1% |
| A-1896893 | 1 | < 0.1% |
| A-1896894 | 1 | < 0.1% |
| A-1896895 | 1 | < 0.1% |
| A-1896896 | 1 | < 0.1% |
| A-1896897 | 1 | < 0.1% |
| Other values (2845332) | 2845332 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| a-1 | 1 | < 0.1% |
| a-6 | 1 | < 0.1% |
| a-42 | 1 | < 0.1% |
| a-24 | 1 | < 0.1% |
| a-22 | 1 | < 0.1% |
| a-86 | 1 | < 0.1% |
| a-11 | 1 | < 0.1% |
| a-3 | 1 | < 0.1% |
| a-4 | 1 | < 0.1% |
| a-5 | 1 | < 0.1% |
| Other values (2845332) | 2845332 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 2845342 | |
| - | 2845342 | |
| 1 | 2728675 | |
| 2 | 2574018 | |
| 3 | 1728617 | |
| 4 | 1723910 | |
| 5 | 1717907 | |
| 6 | 1717564 | |
| 7 | 1717564 | |
| 8 | 1662907 | |
| Other values (2) | 3235128 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 18806290 | |
| Uppercase Letter | 2845342 | 11.6% |
| Dash Punctuation | 2845342 | 11.6% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2728675 | |
| 2 | 2574018 | |
| 3 | 1728617 | |
| 4 | 1723910 | |
| 5 | 1717907 | |
| 6 | 1717564 | |
| 7 | 1717564 | |
| 8 | 1662907 | |
| 9 | 1617564 | |
| 0 | 1617564 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2845342 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2845342 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 21651632 | |
| Latin | 2845342 | 11.6% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| - | 2845342 | |
| 1 | 2728675 | |
| 2 | 2574018 | |
| 3 | 1728617 | |
| 4 | 1723910 | |
| 5 | 1717907 | |
| 6 | 1717564 | |
| 7 | 1717564 | |
| 8 | 1662907 | |
| 9 | 1617564 |
Latin
| Value | Count | Frequency (%) |
| A | 2845342 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 24496974 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 2845342 | |
| - | 2845342 | |
| 1 | 2728675 | |
| 2 | 2574018 | |
| 3 | 1728617 | |
| 4 | 1723910 | |
| 5 | 1717907 | |
| 6 | 1717564 | |
| 7 | 1717564 | |
| 8 | 1662907 | |
| Other values (2) | 3235128 |
Severity
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 21.7 MiB |
| 2 | |
|---|---|
| 3 | 155105 |
| 4 | 131193 |
| 1 | 26053 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2845342 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 2 |
| 3rd row | 2 |
| 4th row | 2 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 2532991 | |
| 3 | 155105 | 5.5% |
| 4 | 131193 | 4.6% |
| 1 | 26053 | 0.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 2532991 | |
| 3 | 155105 | 5.5% |
| 4 | 131193 | 4.6% |
| 1 | 26053 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 2532991 | |
| 3 | 155105 | 5.5% |
| 4 | 131193 | 4.6% |
| 1 | 26053 | 0.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2845342 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 2532991 | |
| 3 | 155105 | 5.5% |
| 4 | 131193 | 4.6% |
| 1 | 26053 | 0.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2845342 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 2532991 | |
| 3 | 155105 | 5.5% |
| 4 | 131193 | 4.6% |
| 1 | 26053 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2845342 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 2532991 | |
| 3 | 155105 | 5.5% |
| 4 | 131193 | 4.6% |
| 1 | 26053 | 0.9% |
Start_Time
Date
| Distinct | 1807311 |
|---|---|
| Distinct (%) | 63.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 21.7 MiB |
| Minimum | 2016-01-14 20:18:33 |
|---|---|
| Maximum | 2021-12-31 23:30:00 |
Histogram with fixed size bins (bins=50)
End_Time
Date
| Distinct | 2239983 |
|---|---|
| Distinct (%) | 78.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 21.7 MiB |
| Minimum | 2016-02-08 06:37:08 |
|---|---|
| Maximum | 2022-01-01 00:00:00 |
Histogram with fixed size bins (bins=50)
Start_Lat
Real number (ℝ)
| Distinct | 1093618 |
|---|---|
| Distinct (%) | 38.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.245201 |
| Minimum | 24.566027 |
|---|---|
| Maximum | 49.00058 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 21.7 MiB |
Quantile statistics
| Minimum | 24.566027 |
|---|---|
| 5-th percentile | 25.961255 |
| Q1 | 33.445174 |
| median | 36.098609 |
| Q3 | 40.160243 |
| 95-th percentile | 45.089827 |
| Maximum | 49.00058 |
| Range | 24.434553 |
| Interquartile range (IQR) | 6.715069 |
Descriptive statistics
| Standard deviation | 5.3637975 |
|---|---|
| Coefficient of variation (CV) | 0.14798642 |
| Kurtosis | -0.58706206 |
| Mean | 36.245201 |
| Median Absolute Deviation (MAD) | 3.376716 |
| Skewness | -0.11463983 |
| Sum | 1.0312999 × 108 |
| Variance | 28.770323 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25.702455 | 348 | < 0.1% |
| 27.447751 | 302 | < 0.1% |
| 28.452192 | 285 | < 0.1% |
| 28.449924 | 268 | < 0.1% |
| 40.85306 | 255 | < 0.1% |
| 25.689146 | 254 | < 0.1% |
| 25.712548 | 238 | < 0.1% |
| 34.020212 | 235 | < 0.1% |
| 28.452939 | 231 | < 0.1% |
| 25.810617 | 227 | < 0.1% |
| Other values (1093608) | 2842699 |
| Value | Count | Frequency (%) |
| 24.566027 | 1 | < 0.1% |
| 24.570087 | 1 | < 0.1% |
| 24.570222 | 1 | < 0.1% |
| 24.57033 | 1 | < 0.1% |
| 24.570584 | 1 | < 0.1% |
| 24.571202 | 3 | |
| 24.57124 | 1 | < 0.1% |
| 24.571308 | 1 | < 0.1% |
| 24.57131 | 1 | < 0.1% |
| 24.571536 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 49.00058 | 1 | < 0.1% |
| 49.00056 | 1 | < 0.1% |
| 49.000269 | 1 | < 0.1% |
| 49.00026 | 1 | < 0.1% |
| 48.99951 | 1 | < 0.1% |
| 48.998445 | 3 | |
| 48.99838 | 1 | < 0.1% |
| 48.997457 | 1 | < 0.1% |
| 48.996539 | 1 | < 0.1% |
| 48.996014 | 1 | < 0.1% |
Start_Lng
Real number (ℝ)
| Distinct | 1120365 |
|---|---|
| Distinct (%) | 39.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -97.114633 |
| Minimum | -124.54807 |
|---|---|
| Maximum | -67.113167 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2845342 |
| Negative (%) | 100.0% |
| Memory size | 21.7 MiB |
Quantile statistics
| Minimum | -124.54807 |
|---|---|
| 5-th percentile | -122.32597 |
| Q1 | -118.03311 |
| median | -92.418076 |
| Q3 | -80.372431 |
| 95-th percentile | -74.174027 |
| Maximum | -67.113167 |
| Range | 57.434907 |
| Interquartile range (IQR) | 37.660681 |
Descriptive statistics
| Standard deviation | 18.317819 |
|---|---|
| Coefficient of variation (CV) | -0.18862059 |
| Kurtosis | -1.64946 |
| Mean | -97.114633 |
| Median Absolute Deviation (MAD) | 15.437108 |
| Skewness | -0.2388874 |
| Sum | -2.7632434 × 108 |
| Variance | 335.5425 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -80.332105 | 348 | < 0.1% |
| -81.400388 | 285 | < 0.1% |
| -81.479136 | 268 | < 0.1% |
| -80.382872 | 254 | < 0.1% |
| -73.96011 | 248 | < 0.1% |
| -80.382427 | 238 | < 0.1% |
| -117.814998 | 235 | < 0.1% |
| -81.400159 | 231 | < 0.1% |
| -77.478828 | 218 | < 0.1% |
| -82.573305 | 216 | < 0.1% |
| Other values (1120355) | 2842801 |
| Value | Count | Frequency (%) |
| -124.548074 | 2 | < 0.1% |
| -124.517744 | 1 | < 0.1% |
| -124.511949 | 1 | < 0.1% |
| -124.497585 | 1 | < 0.1% |
| -124.497567 | 2 | < 0.1% |
| -124.49747 | 1 | < 0.1% |
| -124.497448 | 2 | < 0.1% |
| -124.497438 | 1 | < 0.1% |
| -124.49742 | 5 | |
| -124.49741 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -67.113167 | 1 | |
| -67.403551 | 1 | |
| -67.48413 | 1 | |
| -67.606864 | 1 | |
| -67.606875 | 1 | |
| -67.614387 | 1 | |
| -67.626576 | 1 | |
| -67.70337 | 1 | |
| -67.739696 | 1 | |
| -67.78734 | 1 |
End_Lat
Real number (ℝ)
| Distinct | 1080811 |
|---|---|
| Distinct (%) | 38.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.245321 |
| Minimum | 24.566013 |
|---|---|
| Maximum | 49.075 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 21.7 MiB |
Quantile statistics
| Minimum | 24.566013 |
|---|---|
| 5-th percentile | 25.958574 |
| Q1 | 33.446278 |
| median | 36.097987 |
| Q3 | 40.161049 |
| 95-th percentile | 45.090519 |
| Maximum | 49.075 |
| Range | 24.508987 |
| Interquartile range (IQR) | 6.7147713 |
Descriptive statistics
| Standard deviation | 5.363873 |
|---|---|
| Coefficient of variation (CV) | 0.14798801 |
| Kurtosis | -0.58700212 |
| Mean | 36.245321 |
| Median Absolute Deviation (MAD) | 3.3769205 |
| Skewness | -0.11465709 |
| Sum | 1.0313033 × 108 |
| Variance | 28.771133 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25.701774 | 755 | < 0.1% |
| 25.684322 | 709 | < 0.1% |
| 25.73316 | 589 | < 0.1% |
| 28.449928 | 586 | < 0.1% |
| 28.45019 | 581 | < 0.1% |
| 25.924771 | 576 | < 0.1% |
| 28.450015 | 567 | < 0.1% |
| 25.686252 | 548 | < 0.1% |
| 37.55119 | 525 | < 0.1% |
| 35.842775 | 522 | < 0.1% |
| Other values (1080801) | 2839384 |
| Value | Count | Frequency (%) |
| 24.566013 | 1 | |
| 24.570107 | 1 | |
| 24.57011 | 1 | |
| 24.57018 | 1 | |
| 24.57036 | 1 | |
| 24.570461 | 1 | |
| 24.57124 | 1 | |
| 24.57126 | 1 | |
| 24.571309 | 1 | |
| 24.571389 | 1 |
| Value | Count | Frequency (%) |
| 49.075 | 1 | < 0.1% |
| 49.00214 | 1 | < 0.1% |
| 49.00076 | 3 | |
| 49.00056 | 1 | < 0.1% |
| 48.999922 | 1 | < 0.1% |
| 48.99928 | 1 | < 0.1% |
| 48.999157 | 1 | < 0.1% |
| 48.999132 | 1 | < 0.1% |
| 48.99899 | 1 | < 0.1% |
| 48.998901 | 2 |
End_Lng
Real number (ℝ)
| Distinct | 1105404 |
|---|---|
| Distinct (%) | 38.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -97.114387 |
| Minimum | -124.54575 |
|---|---|
| Maximum | -67.109242 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2845342 |
| Negative (%) | 100.0% |
| Memory size | 21.7 MiB |
Quantile statistics
| Minimum | -124.54575 |
|---|---|
| 5-th percentile | -122.32599 |
| Q1 | -118.03333 |
| median | -92.417718 |
| Q3 | -80.373383 |
| 95-th percentile | -74.173778 |
| Maximum | -67.109242 |
| Range | 57.436506 |
| Interquartile range (IQR) | 37.659948 |
Descriptive statistics
| Standard deviation | 18.317632 |
|---|---|
| Coefficient of variation (CV) | -0.18861914 |
| Kurtosis | -1.6494699 |
| Mean | -97.114387 |
| Median Absolute Deviation (MAD) | 15.437678 |
| Skewness | -0.23888876 |
| Sum | -2.7632364 × 108 |
| Variance | 335.53566 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -80.334179 | 755 | < 0.1% |
| -80.416621 | 709 | < 0.1% |
| -80.336612 | 589 | < 0.1% |
| -81.477219 | 586 | < 0.1% |
| -81.399777 | 583 | < 0.1% |
| -80.293318 | 576 | < 0.1% |
| -81.471375 | 565 | < 0.1% |
| -80.416521 | 547 | < 0.1% |
| -77.475128 | 525 | < 0.1% |
| -78.680237 | 522 | < 0.1% |
| Other values (1105394) | 2839385 |
| Value | Count | Frequency (%) |
| -124.545748 | 2 | < 0.1% |
| -124.509263 | 1 | < 0.1% |
| -124.497829 | 1 | < 0.1% |
| -124.497478 | 2 | < 0.1% |
| -124.49747 | 1 | < 0.1% |
| -124.497438 | 2 | < 0.1% |
| -124.497421 | 1 | < 0.1% |
| -124.497419 | 5 | |
| -124.49741 | 1 | < 0.1% |
| -124.497357 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -67.109242 | 1 | |
| -67.40355 | 1 | |
| -67.48413 | 1 | |
| -67.606864 | 1 | |
| -67.62034 | 1 | |
| -67.626576 | 1 | |
| -67.626605 | 1 | |
| -67.706448 | 1 | |
| -67.739817 | 1 | |
| -67.78734 | 1 |
Distance(mi)
Real number (ℝ)
| Distinct | 14165 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.70267789 |
| Minimum | 0 |
|---|---|
| Maximum | 155.186 |
| Zeros | 385441 |
| Zeros (%) | 13.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 21.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.052 |
| median | 0.244 |
| Q3 | 0.764 |
| 95-th percentile | 2.894 |
| Maximum | 155.186 |
| Range | 155.186 |
| Interquartile range (IQR) | 0.712 |
Descriptive statistics
| Standard deviation | 1.5603608 |
|---|---|
| Coefficient of variation (CV) | 2.2205919 |
| Kurtosis | 806.72437 |
| Mean | 0.70267789 |
| Median Absolute Deviation (MAD) | 0.238 |
| Skewness | 16.670835 |
| Sum | 1999358.9 |
| Variance | 2.4347259 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 385441 | 13.5% |
| 0.008 | 9262 | 0.3% |
| 0.009 | 8978 | 0.3% |
| 0.01 | 8737 | 0.3% |
| 0.007 | 7846 | 0.3% |
| 0.011 | 7319 | 0.3% |
| 0.03 | 6937 | 0.2% |
| 0.012 | 6894 | 0.2% |
| 0.028 | 6789 | 0.2% |
| 0.024 | 6777 | 0.2% |
| Other values (14155) | 2390362 |
| Value | Count | Frequency (%) |
| 0 | 385441 | |
| 0.001 | 4897 | 0.2% |
| 0.002 | 2605 | 0.1% |
| 0.003 | 3388 | 0.1% |
| 0.004 | 4670 | 0.2% |
| 0.005 | 5608 | 0.2% |
| 0.006 | 6687 | 0.2% |
| 0.007 | 7846 | 0.3% |
| 0.008 | 9262 | 0.3% |
| 0.009 | 8978 | 0.3% |
| Value | Count | Frequency (%) |
| 155.186 | 1 | |
| 153.663 | 1 | |
| 152.543 | 1 | |
| 151.525 | 1 | |
| 150.138 | 1 | |
| 149.69 | 1 | |
| 149.687 | 1 | |
| 143.242 | 1 | |
| 138.562 | 1 | |
| 137.618 | 1 |
Description
Categorical
| Distinct | 1174563 |
|---|---|
| Distinct (%) | 41.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 21.7 MiB |
| A crash has occurred causing no to minimum delays. Use caution. | 7978 |
|---|---|
| A crash has occurred use caution. | 2531 |
| An unconfirmed report of a crash has been received. Use caution. | 2308 |
| Hazardous debris is causing no to minimum delays. Use caution. | 2095 |
| At I-15 - Accident. | 2070 |
| Other values (1174558) |
Length
| Max length | 577 |
|---|---|
| Median length | 375 |
| Mean length | 66.621769 |
| Min length | 2 |
Characters and Unicode
| Total characters | 189561718 |
|---|---|
| Distinct characters | 98 |
| Distinct categories | 15 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 4 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 790550 ? |
|---|---|
| Unique (%) | 27.8% |
Sample
| 1st row | Between Sawmill Rd/Exit 20 and OH-315/Olentangy Riv Rd/Exit 22 - Accident. |
|---|---|
| 2nd row | At OH-4/OH-235/Exit 41 - Accident. |
| 3rd row | At I-71/US-50/Exit 1 - Accident. |
| 4th row | At Dart Ave/Exit 21 - Accident. |
| 5th row | At Mitchell Ave/Exit 6 - Accident. |
Common Values
| Value | Count | Frequency (%) |
| A crash has occurred causing no to minimum delays. Use caution. | 7978 | 0.3% |
| A crash has occurred use caution. | 2531 | 0.1% |
| An unconfirmed report of a crash has been received. Use caution. | 2308 | 0.1% |
| Hazardous debris is causing no to minimum delays. Use caution. | 2095 | 0.1% |
| At I-15 - Accident. | 2070 | 0.1% |
| A disabled vehicle is creating a hazard causing no to minimum delays. Use caution. | 1912 | 0.1% |
| At I-5 - Accident. | 1907 | 0.1% |
| At I-405/San Diego Fwy - Accident. | 1769 | 0.1% |
| At I-605 - Accident. | 1486 | 0.1% |
| Incident on I-95 NB near I-95 Drive with caution. | 1304 | < 0.1% |
| Other values (1174553) | 2819982 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| accident | 1798430 | 5.3% |
| to | 1650005 | 4.9% |
| on | 1598467 | 4.8% |
| 1564037 | 4.7% | |
| at | 916875 | 2.7% |
| near | 878801 | 2.6% |
| incident | 856768 | 2.5% |
| from | 796136 | 2.4% |
| due | 782840 | 2.3% |
| rd | 735640 | 2.2% |
| Other values (162605) | 22044277 |
Most occurring characters
| Value | Count | Frequency (%) |
| 30776871 | 16.2% | |
| t | 11717120 | 6.2% |
| e | 10644059 | 5.6% |
| n | 9885855 | 5.2% |
| o | 8424876 | 4.4% |
| i | 8301886 | 4.4% |
| a | 7363979 | 3.9% |
| c | 7074776 | 3.7% |
| d | 6570628 | 3.5% |
| r | 5919544 | 3.1% |
| Other values (88) | 82882124 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 98347096 | |
| Uppercase Letter | 34299454 | 18.1% |
| Space Separator | 30777852 | 16.2% |
| Decimal Number | 12986970 | 6.9% |
| Other Punctuation | 5243233 | 2.8% |
| Dash Punctuation | 5217447 | 2.8% |
| Open Punctuation | 1344559 | 0.7% |
| Close Punctuation | 1344492 | 0.7% |
| Math Symbol | 365 | < 0.1% |
| Modifier Symbol | 102 | < 0.1% |
| Other values (5) | 148 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 11717120 | |
| e | 10644059 | |
| n | 9885855 | |
| o | 8424876 | |
| i | 8301886 | |
| a | 7363979 | 7.5% |
| c | 7074776 | 7.2% |
| d | 6570628 | 6.7% |
| r | 5919544 | 6.0% |
| l | 3533392 | 3.6% |
| Other values (19) | 18910981 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 4238891 | |
| S | 3746799 | 10.9% |
| I | 3061578 | 8.9% |
| E | 2940823 | 8.6% |
| R | 2604603 | 7.6% |
| D | 1817116 | 5.3% |
| N | 1709487 | 5.0% |
| C | 1555252 | 4.5% |
| L | 1501320 | 4.4% |
| B | 1449485 | 4.2% |
| Other values (16) | 9674100 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 3211573 | |
| / | 1897673 | |
| : | 65712 | 1.3% |
| ' | 26434 | 0.5% |
| ; | 25138 | 0.5% |
| * | 7522 | 0.1% |
| & | 5856 | 0.1% |
| # | 2864 | 0.1% |
| @ | 305 | < 0.1% |
| ? | 92 | < 0.1% |
| Other values (4) | 64 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2269949 | |
| 5 | 1571097 | |
| 2 | 1555128 | |
| 0 | 1459676 | |
| 4 | 1186461 | |
| 9 | 1130460 | |
| 3 | 1026620 | |
| 6 | 945893 | |
| 8 | 940013 | |
| 7 | 901673 | 6.9% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1239926 | |
| [ | 101888 | 7.6% |
| { | 2745 | 0.2% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1239866 | |
| ] | 101881 | 7.6% |
| } | 2745 | 0.2% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 161 | |
| = | 135 | |
| ~ | 69 |
Space Separator
| Value | Count | Frequency (%) |
| 30776871 | ||
| Â | 981 | < 0.1% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ^ | 100 | |
| ` | 2 | 2.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5217447 |
Control
| Value | Count | Frequency (%) |
| 96 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 42 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 6 |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 2 |
Other Symbol
| Value | Count | Frequency (%) |
| � | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 132646550 | |
| Common | 56915168 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 11717120 | 8.8% |
| e | 10644059 | 8.0% |
| n | 9885855 | 7.5% |
| o | 8424876 | 6.4% |
| i | 8301886 | 6.3% |
| a | 7363979 | 5.6% |
| c | 7074776 | 5.3% |
| d | 6570628 | 5.0% |
| r | 5919544 | 4.5% |
| A | 4238891 | 3.2% |
| Other values (45) | 52504936 |
Common
| Value | Count | Frequency (%) |
| 30776871 | ||
| - | 5217447 | 9.2% |
| . | 3211573 | 5.6% |
| 1 | 2269949 | 4.0% |
| / | 1897673 | 3.3% |
| 5 | 1571097 | 2.8% |
| 2 | 1555128 | 2.7% |
| 0 | 1459676 | 2.6% |
| ( | 1239926 | 2.2% |
| ) | 1239866 | 2.2% |
| Other values (33) | 6475962 | 11.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 189560715 | |
| None | 997 | < 0.1% |
| Punctuation | 4 | < 0.1% |
| Specials | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 30776871 | 16.2% | |
| t | 11717120 | 6.2% |
| e | 10644059 | 5.6% |
| n | 9885855 | 5.2% |
| o | 8424876 | 4.4% |
| i | 8301886 | 4.4% |
| a | 7363979 | 3.9% |
| c | 7074776 | 3.7% |
| d | 6570628 | 3.5% |
| r | 5919544 | 3.1% |
| Other values (81) | 82881121 |
None
| Value | Count | Frequency (%) |
| Â | 981 | |
| ñ | 8 | 0.8% |
| é | 7 | 0.7% |
| Ã | 1 | 0.1% |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 2 | |
| • | 2 |
Specials
| Value | Count | Frequency (%) |
| � | 2 |
Number
Real number (ℝ)
MISSING SKEWED
| Distinct | 46402 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 1743911 |
| Missing (%) | 61.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8089.4081 |
| Minimum | 0 |
|---|---|
| Maximum | 9999997 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 21.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 108 |
| Q1 | 1270 |
| median | 4007 |
| Q3 | 9567 |
| 95-th percentile | 28661.5 |
| Maximum | 9999997 |
| Range | 9999997 |
| Interquartile range (IQR) | 8297 |
Descriptive statistics
| Standard deviation | 18360.094 |
|---|---|
| Coefficient of variation (CV) | 2.2696462 |
| Kurtosis | 79967.464 |
| Mean | 8089.4081 |
| Median Absolute Deviation (MAD) | 3309 |
| Skewness | 156.94502 |
| Sum | 8.9099249 × 109 |
| Variance | 3.3709305 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 10662 | 0.4% |
| 2 | 8747 | 0.3% |
| 101 | 6706 | 0.2% |
| 100 | 6187 | 0.2% |
| 198 | 2617 | 0.1% |
| 298 | 2270 | 0.1% |
| 200 | 2228 | 0.1% |
| 201 | 2224 | 0.1% |
| 398 | 2191 | 0.1% |
| 199 | 2116 | 0.1% |
| Other values (46392) | 1055483 | |
| (Missing) | 1743911 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 10662 | |
| 2 | 8747 | |
| 3 | 622 | < 0.1% |
| 4 | 557 | < 0.1% |
| 5 | 336 | < 0.1% |
| 6 | 306 | < 0.1% |
| 7 | 256 | < 0.1% |
| 8 | 301 | < 0.1% |
| 9 | 269 | < 0.1% |
| Value | Count | Frequency (%) |
| 9999997 | 1 | |
| 961061 | 1 | |
| 961052 | 1 | |
| 961051 | 2 | |
| 961043 | 1 | |
| 961005 | 1 | |
| 942501 | 1 | |
| 941996 | 1 | |
| 940884 | 1 | |
| 852564 | 1 |
Street
Categorical
| Distinct | 159651 |
|---|---|
| Distinct (%) | 5.6% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 21.7 MiB |
| I-95 N | 39853 |
|---|---|
| I-5 N | 39402 |
| I-95 S | 36425 |
| I-5 S | 30229 |
| I-10 E | 26164 |
| Other values (159646) |
Length
| Max length | 51 |
|---|---|
| Median length | 46 |
| Mean length | 11.162217 |
| Min length | 2 |
Characters and Unicode
| Total characters | 31760302 |
|---|---|
| Distinct characters | 72 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 64154 ? |
|---|---|
| Unique (%) | 2.3% |
Sample
| 1st row | Outerbelt E |
|---|---|
| 2nd row | I-70 E |
| 3rd row | I-75 S |
| 4th row | I-77 N |
| 5th row | I-75 S |
Common Values
| Value | Count | Frequency (%) |
| I-95 N | 39853 | 1.4% |
| I-5 N | 39402 | 1.4% |
| I-95 S | 36425 | 1.3% |
| I-5 S | 30229 | 1.1% |
| I-10 E | 26164 | 0.9% |
| I-10 W | 25298 | 0.9% |
| I-80 W | 17545 | 0.6% |
| I-80 E | 16873 | 0.6% |
| I-405 N | 13708 | 0.5% |
| I-15 N | 12675 | 0.4% |
| Other values (159641) | 2587168 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| n | 514849 | 7.1% |
| s | 512084 | 7.1% |
| w | 394072 | 5.5% |
| e | 392955 | 5.5% |
| rd | 344344 | 4.8% |
| ave | 228318 | 3.2% |
| st | 215172 | 3.0% |
| fwy | 149795 | 2.1% |
| highway | 149101 | 2.1% |
| blvd | 112666 | 1.6% |
| Other values (43749) | 4195437 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5464883 | 17.2% | |
| e | 1620891 | 5.1% |
| a | 1390354 | 4.4% |
| S | 1151559 | 3.6% |
| t | 1124812 | 3.5% |
| - | 1076858 | 3.4% |
| r | 1050604 | 3.3% |
| o | 1041312 | 3.3% |
| n | 1002552 | 3.2% |
| l | 939981 | 3.0% |
| Other values (62) | 15896496 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 14683462 | |
| Uppercase Letter | 7354331 | |
| Space Separator | 5464883 | 17.2% |
| Decimal Number | 3163551 | 10.0% |
| Dash Punctuation | 1076858 | 3.4% |
| Other Punctuation | 16875 | 0.1% |
| Other Symbol | 342 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1620891 | |
| a | 1390354 | 9.5% |
| t | 1124812 | 7.7% |
| r | 1050604 | 7.2% |
| o | 1041312 | 7.1% |
| n | 1002552 | 6.8% |
| l | 939981 | 6.4% |
| i | 913631 | 6.2% |
| d | 897396 | 6.1% |
| y | 797274 | 5.4% |
| Other values (18) | 3904655 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1151559 | |
| I | 819857 | |
| N | 655079 | |
| W | 606436 | 8.2% |
| E | 556151 | 7.6% |
| A | 488039 | 6.6% |
| R | 479994 | 6.5% |
| C | 373251 | 5.1% |
| H | 361322 | 4.9% |
| B | 313233 | 4.3% |
| Other values (16) | 1549410 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 493665 | |
| 0 | 451804 | |
| 1 | 442418 | |
| 9 | 319319 | |
| 4 | 295166 | |
| 2 | 266844 | |
| 8 | 262531 | |
| 7 | 229622 | |
| 6 | 227316 | |
| 3 | 174866 | 5.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 11457 | |
| . | 4230 | 25.1% |
| / | 1186 | 7.0% |
| & | 1 | < 0.1% |
| ; | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 5464883 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1076858 |
Other Symbol
| Value | Count | Frequency (%) |
| � | 342 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 22037793 | |
| Common | 9722509 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1620891 | 7.4% |
| a | 1390354 | 6.3% |
| S | 1151559 | 5.2% |
| t | 1124812 | 5.1% |
| r | 1050604 | 4.8% |
| o | 1041312 | 4.7% |
| n | 1002552 | 4.5% |
| l | 939981 | 4.3% |
| i | 913631 | 4.1% |
| d | 897396 | 4.1% |
| Other values (44) | 10904701 |
Common
| Value | Count | Frequency (%) |
| 5464883 | ||
| - | 1076858 | 11.1% |
| 5 | 493665 | 5.1% |
| 0 | 451804 | 4.6% |
| 1 | 442418 | 4.6% |
| 9 | 319319 | 3.3% |
| 4 | 295166 | 3.0% |
| 2 | 266844 | 2.7% |
| 8 | 262531 | 2.7% |
| 7 | 229622 | 2.4% |
| Other values (8) | 419399 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 31759462 | |
| None | 498 | < 0.1% |
| Specials | 342 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5464883 | 17.2% | |
| e | 1620891 | 5.1% |
| a | 1390354 | 4.4% |
| S | 1151559 | 3.6% |
| t | 1124812 | 3.5% |
| - | 1076858 | 3.4% |
| r | 1050604 | 3.3% |
| o | 1041312 | 3.3% |
| n | 1002552 | 3.2% |
| l | 939981 | 3.0% |
| Other values (59) | 15895656 |
None
| Value | Count | Frequency (%) |
| é | 489 | |
| ñ | 9 | 1.8% |
Specials
| Value | Count | Frequency (%) |
| � | 342 |
Side
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 21.7 MiB |
| R | |
|---|---|
| L | |
| N | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2845342 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | R |
|---|---|
| 2nd row | R |
| 3rd row | R |
| 4th row | R |
| 5th row | R |
Common Values
| Value | Count | Frequency (%) |
| R | 2353309 | |
| L | 492032 | 17.3% |
| N | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| r | 2353309 | |
| l | 492032 | 17.3% |
| n | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 2353309 | |
| L | 492032 | 17.3% |
| N | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2845342 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 2353309 | |
| L | 492032 | 17.3% |
| N | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2845342 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 2353309 | |
| L | 492032 | 17.3% |
| N | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2845342 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 2353309 | |
| L | 492032 | 17.3% |
| N | 1 | < 0.1% |
City
Categorical
| Distinct | 11681 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 137 |
| Missing (%) | < 0.1% |
| Memory size | 21.7 MiB |
| Miami | 106966 |
|---|---|
| Los Angeles | 68956 |
| Orlando | 54691 |
| Dallas | 41979 |
| Houston | 39448 |
| Other values (11676) |
Length
| Max length | 30 |
|---|---|
| Median length | 26 |
| Mean length | 8.8105012 |
| Min length | 3 |
Characters and Unicode
| Total characters | 25067682 |
|---|---|
| Distinct characters | 65 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1110 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Dublin |
|---|---|
| 2nd row | Dayton |
| 3rd row | Cincinnati |
| 4th row | Akron |
| 5th row | Cincinnati |
Common Values
| Value | Count | Frequency (%) |
| Miami | 106966 | 3.8% |
| Los Angeles | 68956 | 2.4% |
| Orlando | 54691 | 1.9% |
| Dallas | 41979 | 1.5% |
| Houston | 39448 | 1.4% |
| Charlotte | 33152 | 1.2% |
| Sacramento | 32559 | 1.1% |
| San Diego | 26627 | 0.9% |
| Raleigh | 22840 | 0.8% |
| Minneapolis | 22768 | 0.8% |
| Other values (11671) | 2395219 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| miami | 119442 | 3.2% |
| san | 87961 | 2.4% |
| los | 74220 | 2.0% |
| city | 69201 | 1.9% |
| angeles | 69027 | 1.9% |
| orlando | 54691 | 1.5% |
| dallas | 42171 | 1.1% |
| saint | 40075 | 1.1% |
| houston | 39455 | 1.1% |
| beach | 39263 | 1.1% |
| Other values (9456) | 3086433 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2502556 | 10.0% |
| e | 2221044 | 8.9% |
| n | 1890139 | 7.5% |
| o | 1878078 | 7.5% |
| l | 1661139 | 6.6% |
| i | 1634406 | 6.5% |
| r | 1492423 | 6.0% |
| t | 1316077 | 5.3% |
| s | 1161930 | 4.6% |
| 876734 | 3.5% | |
| Other values (55) | 8433156 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 20468277 | |
| Uppercase Letter | 3721941 | 14.8% |
| Space Separator | 876734 | 3.5% |
| Dash Punctuation | 320 | < 0.1% |
| Decimal Number | 255 | < 0.1% |
| Other Punctuation | 155 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 2502556 | |
| e | 2221044 | |
| n | 1890139 | |
| o | 1878078 | |
| l | 1661139 | |
| i | 1634406 | |
| r | 1492423 | 7.3% |
| t | 1316077 | 6.4% |
| s | 1161930 | 5.7% |
| d | 645556 | 3.2% |
| Other values (16) | 4064929 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 392746 | 10.6% |
| C | 362436 | 9.7% |
| M | 333442 | 9.0% |
| L | 266542 | 7.2% |
| B | 259083 | 7.0% |
| P | 242493 | 6.5% |
| A | 220680 | 5.9% |
| H | 200735 | 5.4% |
| R | 187703 | 5.0% |
| O | 160396 | 4.3% |
| Other values (16) | 1095685 |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 162 | |
| 5 | 40 | 15.7% |
| 7 | 19 | 7.5% |
| 1 | 16 | 6.3% |
| 6 | 5 | 2.0% |
| 8 | 3 | 1.2% |
| 2 | 3 | 1.2% |
| 3 | 3 | 1.2% |
| 0 | 2 | 0.8% |
| 9 | 2 | 0.8% |
Space Separator
| Value | Count | Frequency (%) |
| 876734 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 320 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 155 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 24190218 | |
| Common | 877464 | 3.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 2502556 | 10.3% |
| e | 2221044 | 9.2% |
| n | 1890139 | 7.8% |
| o | 1878078 | 7.8% |
| l | 1661139 | 6.9% |
| i | 1634406 | 6.8% |
| r | 1492423 | 6.2% |
| t | 1316077 | 5.4% |
| s | 1161930 | 4.8% |
| d | 645556 | 2.7% |
| Other values (42) | 7786870 |
Common
| Value | Count | Frequency (%) |
| 876734 | ||
| - | 320 | < 0.1% |
| 4 | 162 | < 0.1% |
| . | 155 | < 0.1% |
| 5 | 40 | < 0.1% |
| 7 | 19 | < 0.1% |
| 1 | 16 | < 0.1% |
| 6 | 5 | < 0.1% |
| 8 | 3 | < 0.1% |
| 2 | 3 | < 0.1% |
| Other values (3) | 7 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 25067682 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 2502556 | 10.0% |
| e | 2221044 | 8.9% |
| n | 1890139 | 7.5% |
| o | 1878078 | 7.5% |
| l | 1661139 | 6.6% |
| i | 1634406 | 6.5% |
| r | 1492423 | 6.0% |
| t | 1316077 | 5.3% |
| s | 1161930 | 4.6% |
| 876734 | 3.5% | |
| Other values (55) | 8433156 |
County
Categorical
| Distinct | 1707 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 21.7 MiB |
| Los Angeles | |
|---|---|
| Miami-Dade | 143939 |
| Orange | 114917 |
| San Bernardino | 55018 |
| Dallas | 50050 |
| Other values (1702) |
Length
| Max length | 20 |
|---|---|
| Median length | 16 |
| Mean length | 8.1958745 |
| Min length | 3 |
Characters and Unicode
| Total characters | 23320066 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 66 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Franklin |
|---|---|
| 2nd row | Montgomery |
| 3rd row | Hamilton |
| 4th row | Summit |
| 5th row | Hamilton |
Common Values
| Value | Count | Frequency (%) |
| Los Angeles | 234122 | 8.2% |
| Miami-Dade | 143939 | 5.1% |
| Orange | 114917 | 4.0% |
| San Bernardino | 55018 | 1.9% |
| Dallas | 50050 | 1.8% |
| San Diego | 48366 | 1.7% |
| Sacramento | 46708 | 1.6% |
| Harris | 42559 | 1.5% |
| Riverside | 42176 | 1.5% |
| Montgomery | 41476 | 1.5% |
| Other values (1697) | 2026011 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| los | 234123 | 6.6% |
| angeles | 234122 | 6.6% |
| san | 145652 | 4.1% |
| miami-dade | 143939 | 4.1% |
| orange | 114917 | 3.3% |
| bernardino | 55018 | 1.6% |
| dallas | 50050 | 1.4% |
| diego | 48366 | 1.4% |
| sacramento | 46708 | 1.3% |
| santa | 43738 | 1.2% |
| Other values (1668) | 2418952 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2602218 | 11.2% |
| e | 2445101 | 10.5% |
| n | 1899466 | 8.1% |
| o | 1619413 | 6.9% |
| r | 1442849 | 6.2% |
| i | 1307901 | 5.6% |
| s | 1284451 | 5.5% |
| l | 1157072 | 5.0% |
| t | 785883 | 3.4% |
| 690243 | 3.0% | |
| Other values (47) | 8085469 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 18767444 | |
| Uppercase Letter | 3684912 | 15.8% |
| Space Separator | 690243 | 3.0% |
| Dash Punctuation | 144233 | 0.6% |
| Other Punctuation | 33203 | 0.1% |
| Other Symbol | 31 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 2602218 | |
| e | 2445101 | |
| n | 1899466 | |
| o | 1619413 | |
| r | 1442849 | |
| i | 1307901 | 7.0% |
| s | 1284451 | 6.8% |
| l | 1157072 | 6.2% |
| t | 785883 | 4.2% |
| g | 678325 | 3.6% |
| Other values (17) | 3544765 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 414228 | |
| S | 394862 | |
| L | 372320 | |
| D | 369042 | |
| A | 336667 | |
| C | 287055 | 7.8% |
| B | 212764 | 5.8% |
| H | 173937 | 4.7% |
| O | 173249 | 4.7% |
| P | 139348 | 3.8% |
| Other values (15) | 811440 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 18431 | |
| ' | 14772 |
Space Separator
| Value | Count | Frequency (%) |
| 690243 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 144233 |
Other Symbol
| Value | Count | Frequency (%) |
| � | 31 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 22452356 | |
| Common | 867710 | 3.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 2602218 | 11.6% |
| e | 2445101 | 10.9% |
| n | 1899466 | 8.5% |
| o | 1619413 | 7.2% |
| r | 1442849 | 6.4% |
| i | 1307901 | 5.8% |
| s | 1284451 | 5.7% |
| l | 1157072 | 5.2% |
| t | 785883 | 3.5% |
| g | 678325 | 3.0% |
| Other values (42) | 7229677 |
Common
| Value | Count | Frequency (%) |
| 690243 | ||
| - | 144233 | 16.6% |
| . | 18431 | 2.1% |
| ' | 14772 | 1.7% |
| � | 31 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 23319942 | |
| None | 93 | < 0.1% |
| Specials | 31 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 2602218 | 11.2% |
| e | 2445101 | 10.5% |
| n | 1899466 | 8.1% |
| o | 1619413 | 6.9% |
| r | 1442849 | 6.2% |
| i | 1307901 | 5.6% |
| s | 1284451 | 5.5% |
| l | 1157072 | 5.0% |
| t | 785883 | 3.4% |
| 690243 | 3.0% | |
| Other values (45) | 8085345 |
None
| Value | Count | Frequency (%) |
| ñ | 93 |
Specials
| Value | Count | Frequency (%) |
| � | 31 |
State
Categorical
| Distinct | 49 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 21.7 MiB |
| CA | |
|---|---|
| FL | |
| TX | |
| OR | |
| VA | 113535 |
| Other values (44) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 5690684 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | OH |
|---|---|
| 2nd row | OH |
| 3rd row | OH |
| 4th row | OH |
| 5th row | OH |
Common Values
| Value | Count | Frequency (%) |
| CA | 795868 | |
| FL | 401388 | |
| TX | 149037 | 5.2% |
| OR | 126341 | 4.4% |
| VA | 113535 | 4.0% |
| NY | 108049 | 3.8% |
| PA | 99975 | 3.5% |
| MN | 97185 | 3.4% |
| NC | 91362 | 3.2% |
| SC | 89216 | 3.1% |
| Other values (39) | 773386 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| ca | 795868 | |
| fl | 401388 | |
| tx | 149037 | 5.2% |
| or | 126341 | 4.4% |
| va | 113535 | 4.0% |
| ny | 108049 | 3.8% |
| pa | 99975 | 3.5% |
| mn | 97185 | 3.4% |
| nc | 91362 | 3.2% |
| sc | 89216 | 3.1% |
| Other values (39) | 773386 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1232010 | |
| C | 1040681 | |
| L | 515047 | |
| N | 440972 | 7.7% |
| F | 401388 | 7.1% |
| T | 296934 | 5.2% |
| M | 267985 | 4.7% |
| O | 214529 | 3.8% |
| X | 149037 | 2.6% |
| I | 142296 | 2.5% |
| Other values (14) | 989805 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 5690684 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 1232010 | |
| C | 1040681 | |
| L | 515047 | |
| N | 440972 | 7.7% |
| F | 401388 | 7.1% |
| T | 296934 | 5.2% |
| M | 267985 | 4.7% |
| O | 214529 | 3.8% |
| X | 149037 | 2.6% |
| I | 142296 | 2.5% |
| Other values (14) | 989805 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5690684 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 1232010 | |
| C | 1040681 | |
| L | 515047 | |
| N | 440972 | 7.7% |
| F | 401388 | 7.1% |
| T | 296934 | 5.2% |
| M | 267985 | 4.7% |
| O | 214529 | 3.8% |
| X | 149037 | 2.6% |
| I | 142296 | 2.5% |
| Other values (14) | 989805 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5690684 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 1232010 | |
| C | 1040681 | |
| L | 515047 | |
| N | 440972 | 7.7% |
| F | 401388 | 7.1% |
| T | 296934 | 5.2% |
| M | 267985 | 4.7% |
| O | 214529 | 3.8% |
| X | 149037 | 2.6% |
| I | 142296 | 2.5% |
| Other values (14) | 989805 |
Zipcode
Categorical
| Distinct | 363085 |
|---|---|
| Distinct (%) | 12.8% |
| Missing | 1319 |
| Missing (%) | < 0.1% |
| Memory size | 21.7 MiB |
| 91761 | 6162 |
|---|---|
| 33186 | 5248 |
| 92407 | 4528 |
| 92507 | 4527 |
| 91706 | 4471 |
| Other values (363080) |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 6.4097372 |
| Min length | 5 |
Characters and Unicode
| Total characters | 18229440 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 209614 ? |
|---|---|
| Unique (%) | 7.4% |
Sample
| 1st row | 43017 |
|---|---|
| 2nd row | 45424 |
| 3rd row | 45203 |
| 4th row | 44311 |
| 5th row | 45217 |
Common Values
| Value | Count | Frequency (%) |
| 91761 | 6162 | 0.2% |
| 33186 | 5248 | 0.2% |
| 92407 | 4528 | 0.2% |
| 92507 | 4527 | 0.2% |
| 91706 | 4471 | 0.2% |
| 33183 | 3518 | 0.1% |
| 92324 | 3491 | 0.1% |
| 32819 | 3455 | 0.1% |
| 33169 | 3439 | 0.1% |
| 91765 | 3189 | 0.1% |
| Other values (363075) | 2801995 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 91761 | 6162 | 0.2% |
| 33186 | 5248 | 0.2% |
| 92407 | 4528 | 0.2% |
| 92507 | 4527 | 0.2% |
| 91706 | 4471 | 0.2% |
| 33183 | 3518 | 0.1% |
| 92324 | 3491 | 0.1% |
| 32819 | 3455 | 0.1% |
| 33169 | 3439 | 0.1% |
| 91765 | 3189 | 0.1% |
| Other values (363075) | 2801995 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2252352 | |
| 2 | 2174309 | |
| 3 | 2173091 | |
| 1 | 2043786 | |
| 9 | 1788058 | |
| 5 | 1575164 | |
| 7 | 1519116 | |
| 4 | 1485471 | |
| 6 | 1243905 | |
| 8 | 1172323 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17427575 | |
| Dash Punctuation | 801865 | 4.4% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2252352 | |
| 2 | 2174309 | |
| 3 | 2173091 | |
| 1 | 2043786 | |
| 9 | 1788058 | |
| 5 | 1575164 | |
| 7 | 1519116 | |
| 4 | 1485471 | |
| 6 | 1243905 | |
| 8 | 1172323 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 801865 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 18229440 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 2252352 | |
| 2 | 2174309 | |
| 3 | 2173091 | |
| 1 | 2043786 | |
| 9 | 1788058 | |
| 5 | 1575164 | |
| 7 | 1519116 | |
| 4 | 1485471 | |
| 6 | 1243905 | |
| 8 | 1172323 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18229440 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 2252352 | |
| 2 | 2174309 | |
| 3 | 2173091 | |
| 1 | 2043786 | |
| 9 | 1788058 | |
| 5 | 1575164 | |
| 7 | 1519116 | |
| 4 | 1485471 | |
| 6 | 1243905 | |
| 8 | 1172323 |
Country
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 21.7 MiB |
| US |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 5690684 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
Common Values
| Value | Count | Frequency (%) |
| US | 2845342 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| us | 2845342 |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 2845342 | |
| S | 2845342 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 5690684 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 2845342 | |
| S | 2845342 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5690684 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| U | 2845342 | |
| S | 2845342 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5690684 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| U | 2845342 | |
| S | 2845342 |
Timezone
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3659 |
| Missing (%) | 0.1% |
| Memory size | 21.7 MiB |
| US/Eastern | |
|---|---|
| US/Pacific | |
| US/Central | |
| US/Mountain |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 10.057922 |
| Min length | 10 |
Characters and Unicode
| Total characters | 28581427 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | US/Eastern |
|---|---|
| 2nd row | US/Eastern |
| 3rd row | US/Eastern |
| 4th row | US/Eastern |
| 5th row | US/Eastern |
Common Values
| Value | Count | Frequency (%) |
| US/Eastern | 1221927 | |
| US/Pacific | 967094 | |
| US/Central | 488065 | 17.2% |
| US/Mountain | 164597 | 5.8% |
| (Missing) | 3659 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| us/eastern | 1221927 | |
| us/pacific | 967094 | |
| us/central | 488065 | 17.2% |
| us/mountain | 164597 | 5.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 2841683 | |
| S | 2841683 | |
| / | 2841683 | |
| a | 2841683 | |
| i | 2098785 | 7.3% |
| n | 2039186 | 7.1% |
| c | 1934188 | 6.8% |
| t | 1874589 | 6.6% |
| e | 1709992 | 6.0% |
| r | 1709992 | 6.0% |
| Other values (9) | 5847963 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 17214695 | |
| Uppercase Letter | 8525049 | |
| Other Punctuation | 2841683 | 9.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 2841683 | |
| i | 2098785 | |
| n | 2039186 | |
| c | 1934188 | |
| t | 1874589 | |
| e | 1709992 | |
| r | 1709992 | |
| s | 1221927 | |
| f | 967094 | 5.6% |
| l | 488065 | 2.8% |
| Other values (2) | 329194 | 1.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 2841683 | |
| S | 2841683 | |
| E | 1221927 | |
| P | 967094 | 11.3% |
| C | 488065 | 5.7% |
| M | 164597 | 1.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 2841683 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 25739744 | |
| Common | 2841683 | 9.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| U | 2841683 | |
| S | 2841683 | |
| a | 2841683 | |
| i | 2098785 | |
| n | 2039186 | |
| c | 1934188 | |
| t | 1874589 | |
| e | 1709992 | 6.6% |
| r | 1709992 | 6.6% |
| s | 1221927 | 4.7% |
| Other values (8) | 4626036 |
Common
| Value | Count | Frequency (%) |
| / | 2841683 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 28581427 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| U | 2841683 | |
| S | 2841683 | |
| / | 2841683 | |
| a | 2841683 | |
| i | 2098785 | 7.3% |
| n | 2039186 | 7.1% |
| c | 1934188 | 6.8% |
| t | 1874589 | 6.6% |
| e | 1709992 | 6.0% |
| r | 1709992 | 6.0% |
| Other values (9) | 5847963 |
Airport_Code
Categorical
| Distinct | 2004 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 9549 |
| Missing (%) | 0.3% |
| Memory size | 21.7 MiB |
| KCQT | 52790 |
|---|---|
| KMIA | 45740 |
| KORL | 39380 |
| KOPF | 38556 |
| KTMB | 36250 |
| Other values (1999) |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 11343172 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 48 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | KOSU |
|---|---|
| 2nd row | KFFO |
| 3rd row | KLUK |
| 4th row | KAKR |
| 5th row | KLUK |
Common Values
| Value | Count | Frequency (%) |
| KCQT | 52790 | 1.9% |
| KMIA | 45740 | 1.6% |
| KORL | 39380 | 1.4% |
| KOPF | 38556 | 1.4% |
| KTMB | 36250 | 1.3% |
| KEMT | 29931 | 1.1% |
| KRDU | 29322 | 1.0% |
| KFUL | 28575 | 1.0% |
| KHHR | 27305 | 1.0% |
| KBNA | 27061 | 1.0% |
| Other values (1994) | 2480883 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| kcqt | 52790 | 1.9% |
| kmia | 45740 | 1.6% |
| korl | 39380 | 1.4% |
| kopf | 38556 | 1.4% |
| ktmb | 36250 | 1.3% |
| kemt | 29931 | 1.1% |
| krdu | 29322 | 1.0% |
| kful | 28575 | 1.0% |
| khhr | 27305 | 1.0% |
| kbna | 27061 | 1.0% |
| Other values (1994) | 2480883 |
Most occurring characters
| Value | Count | Frequency (%) |
| K | 2996056 | |
| A | 594595 | 5.2% |
| C | 587310 | 5.2% |
| M | 541139 | 4.8% |
| S | 498222 | 4.4% |
| T | 476820 | 4.2% |
| L | 467659 | 4.1% |
| O | 449386 | 4.0% |
| R | 439134 | 3.9% |
| D | 437371 | 3.9% |
| Other values (26) | 3855480 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 11189338 | |
| Decimal Number | 153834 | 1.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| K | 2996056 | |
| A | 594595 | 5.3% |
| C | 587310 | 5.2% |
| M | 541139 | 4.8% |
| S | 498222 | 4.5% |
| T | 476820 | 4.3% |
| L | 467659 | 4.2% |
| O | 449386 | 4.0% |
| R | 439134 | 3.9% |
| D | 437371 | 3.9% |
| Other values (16) | 3701646 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 33233 | |
| 6 | 25327 | |
| 4 | 23061 | |
| 3 | 16538 | |
| 7 | 13339 | |
| 0 | 12452 | 8.1% |
| 9 | 10951 | 7.1% |
| 1 | 10758 | 7.0% |
| 8 | 4389 | 2.9% |
| 5 | 3786 | 2.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11189338 | |
| Common | 153834 | 1.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| K | 2996056 | |
| A | 594595 | 5.3% |
| C | 587310 | 5.2% |
| M | 541139 | 4.8% |
| S | 498222 | 4.5% |
| T | 476820 | 4.3% |
| L | 467659 | 4.2% |
| O | 449386 | 4.0% |
| R | 439134 | 3.9% |
| D | 437371 | 3.9% |
| Other values (16) | 3701646 |
Common
| Value | Count | Frequency (%) |
| 2 | 33233 | |
| 6 | 25327 | |
| 4 | 23061 | |
| 3 | 16538 | |
| 7 | 13339 | |
| 0 | 12452 | 8.1% |
| 9 | 10951 | 7.1% |
| 1 | 10758 | 7.0% |
| 8 | 4389 | 2.9% |
| 5 | 3786 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11343172 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| K | 2996056 | |
| A | 594595 | 5.2% |
| C | 587310 | 5.2% |
| M | 541139 | 4.8% |
| S | 498222 | 4.4% |
| T | 476820 | 4.2% |
| L | 467659 | 4.1% |
| O | 449386 | 4.0% |
| R | 439134 | 3.9% |
| D | 437371 | 3.9% |
| Other values (26) | 3855480 |
Weather_Timestamp
Categorical
HIGH CARDINALITY MISSING
| Distinct | 474214 |
|---|---|
| Distinct (%) | 17.0% |
| Missing | 50736 |
| Missing (%) | 1.8% |
| Memory size | 21.7 MiB |
| 2021-12-17 14:53:00 | 640 |
|---|---|
| 2021-12-23 14:53:00 | 629 |
| 2021-01-26 15:53:00 | 598 |
| 2021-12-06 16:53:00 | 595 |
| 2021-12-03 16:53:00 | 593 |
| Other values (474209) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 53097514 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 186552 ? |
|---|---|
| Unique (%) | 6.7% |
Sample
| 1st row | 2016-02-08 00:53:00 |
|---|---|
| 2nd row | 2016-02-08 05:58:00 |
| 3rd row | 2016-02-08 05:53:00 |
| 4th row | 2016-02-08 06:54:00 |
| 5th row | 2016-02-08 07:53:00 |
Common Values
| Value | Count | Frequency (%) |
| 2021-12-17 14:53:00 | 640 | < 0.1% |
| 2021-12-23 14:53:00 | 629 | < 0.1% |
| 2021-01-26 15:53:00 | 598 | < 0.1% |
| 2021-12-06 16:53:00 | 595 | < 0.1% |
| 2021-12-03 16:53:00 | 593 | < 0.1% |
| 2021-12-17 17:53:00 | 572 | < 0.1% |
| 2021-11-30 16:53:00 | 569 | < 0.1% |
| 2021-12-15 16:53:00 | 567 | < 0.1% |
| 2021-12-03 14:53:00 | 565 | < 0.1% |
| 2021-12-07 16:53:00 | 560 | < 0.1% |
| Other values (474204) | 2788718 | |
| (Missing) | 50736 | 1.8% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 16:53:00 | 95753 | 1.7% |
| 15:53:00 | 94214 | 1.7% |
| 14:53:00 | 88219 | 1.6% |
| 17:53:00 | 85653 | 1.5% |
| 13:53:00 | 75857 | 1.4% |
| 12:53:00 | 66186 | 1.2% |
| 18:53:00 | 59874 | 1.1% |
| 07:53:00 | 55202 | 1.0% |
| 11:53:00 | 50706 | 0.9% |
| 08:53:00 | 46872 | 0.8% |
| Other values (3529) | 4870676 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 13312181 | |
| 2 | 7541273 | |
| 1 | 7373996 | |
| - | 5589212 | |
| : | 5589212 | |
| 5 | 3411025 | 6.4% |
| 2794606 | 5.3% | |
| 3 | 2200904 | 4.1% |
| 6 | 1217216 | 2.3% |
| 4 | 1064424 | 2.0% |
| Other values (3) | 3003465 | 5.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 39124484 | |
| Dash Punctuation | 5589212 | 10.5% |
| Other Punctuation | 5589212 | 10.5% |
| Space Separator | 2794606 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 13312181 | |
| 2 | 7541273 | |
| 1 | 7373996 | |
| 5 | 3411025 | 8.7% |
| 3 | 2200904 | 5.6% |
| 6 | 1217216 | 3.1% |
| 4 | 1064424 | 2.7% |
| 7 | 1029347 | 2.6% |
| 9 | 1012235 | 2.6% |
| 8 | 961883 | 2.5% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5589212 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 5589212 |
Space Separator
| Value | Count | Frequency (%) |
| 2794606 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 53097514 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 13312181 | |
| 2 | 7541273 | |
| 1 | 7373996 | |
| - | 5589212 | |
| : | 5589212 | |
| 5 | 3411025 | 6.4% |
| 2794606 | 5.3% | |
| 3 | 2200904 | 4.1% |
| 6 | 1217216 | 2.3% |
| 4 | 1064424 | 2.0% |
| Other values (3) | 3003465 | 5.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 53097514 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 13312181 | |
| 2 | 7541273 | |
| 1 | 7373996 | |
| - | 5589212 | |
| : | 5589212 | |
| 5 | 3411025 | 6.4% |
| 2794606 | 5.3% | |
| 3 | 2200904 | 4.1% |
| 6 | 1217216 | 2.3% |
| 4 | 1064424 | 2.0% |
| Other values (3) | 3003465 | 5.7% |
Temperature(F)
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 788 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 69274 |
| Missing (%) | 2.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.793556 |
| Minimum | -89 |
|---|---|
| Maximum | 196 |
| Zeros | 984 |
| Zeros (%) | < 0.1% |
| Negative | 6444 |
| Negative (%) | 0.2% |
| Memory size | 21.7 MiB |
Quantile statistics
| Minimum | -89 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 50 |
| median | 64 |
| Q3 | 76 |
| 95-th percentile | 88.9 |
| Maximum | 196 |
| Range | 285 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 18.622629 |
|---|---|
| Coefficient of variation (CV) | 0.30136847 |
| Kurtosis | 0.030021552 |
| Mean | 61.793556 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | -0.49107947 |
| Sum | 1.7154311 × 108 |
| Variance | 346.80233 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 73 | 64505 | 2.3% |
| 77 | 63575 | 2.2% |
| 75 | 60534 | 2.1% |
| 72 | 59681 | 2.1% |
| 68 | 58557 | 2.1% |
| 63 | 58259 | 2.0% |
| 64 | 57937 | 2.0% |
| 70 | 57760 | 2.0% |
| 66 | 56336 | 2.0% |
| 59 | 56025 | 2.0% |
| Other values (778) | 2182899 | |
| (Missing) | 69274 | 2.4% |
| Value | Count | Frequency (%) |
| -89 | 2 | |
| -77.8 | 1 | < 0.1% |
| -58 | 1 | < 0.1% |
| -50 | 1 | < 0.1% |
| -40 | 1 | < 0.1% |
| -33 | 1 | < 0.1% |
| -30 | 1 | < 0.1% |
| -29 | 4 | |
| -28 | 2 | |
| -27.9 | 2 |
| Value | Count | Frequency (%) |
| 196 | 3 | < 0.1% |
| 170.6 | 1 | < 0.1% |
| 168.8 | 1 | < 0.1% |
| 156 | 1 | < 0.1% |
| 144 | 1 | < 0.1% |
| 136 | 1 | < 0.1% |
| 129.2 | 1 | < 0.1% |
| 127.4 | 1 | < 0.1% |
| 120 | 8 | |
| 119 | 5 |
Wind_Chill(F)
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 897 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 469643 |
| Missing (%) | 16.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59.658231 |
| Minimum | -89 |
|---|---|
| Maximum | 196 |
| Zeros | 1322 |
| Zeros (%) | < 0.1% |
| Negative | 20659 |
| Negative (%) | 0.7% |
| Memory size | 21.7 MiB |
Quantile statistics
| Minimum | -89 |
|---|---|
| 5-th percentile | 21 |
| Q1 | 46 |
| median | 63 |
| Q3 | 76 |
| 95-th percentile | 88 |
| Maximum | 196 |
| Range | 285 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 21.160967 |
|---|---|
| Coefficient of variation (CV) | 0.35470323 |
| Kurtosis | 0.36821114 |
| Mean | 59.658231 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | -0.70827227 |
| Sum | 1.4173 × 108 |
| Variance | 447.78654 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 73 | 56492 | 2.0% |
| 77 | 53359 | 1.9% |
| 75 | 52898 | 1.9% |
| 72 | 52196 | 1.8% |
| 63 | 50784 | 1.8% |
| 64 | 50374 | 1.8% |
| 70 | 50187 | 1.8% |
| 79 | 48936 | 1.7% |
| 66 | 48929 | 1.7% |
| 68 | 48517 | 1.7% |
| Other values (887) | 1863027 | |
| (Missing) | 469643 | 16.5% |
| Value | Count | Frequency (%) |
| -89 | 2 | |
| -80 | 1 | < 0.1% |
| -65.9 | 1 | < 0.1% |
| -59 | 1 | < 0.1% |
| -58 | 1 | < 0.1% |
| -53.5 | 4 | |
| -53.1 | 1 | < 0.1% |
| -52.3 | 1 | < 0.1% |
| -51.7 | 1 | < 0.1% |
| -51.5 | 2 |
| Value | Count | Frequency (%) |
| 196 | 3 | < 0.1% |
| 156 | 1 | < 0.1% |
| 144 | 1 | < 0.1% |
| 136 | 1 | < 0.1% |
| 120 | 8 | < 0.1% |
| 119 | 5 | < 0.1% |
| 117 | 11 | < 0.1% |
| 116 | 8 | < 0.1% |
| 115 | 13 | < 0.1% |
| 114 | 36 |
Humidity(%)
Real number (ℝ)
| Distinct | 100 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 73092 |
| Missing (%) | 2.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 64.365452 |
| Minimum | 1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 21.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 23 |
| Q1 | 48 |
| median | 67 |
| Q3 | 83 |
| 95-th percentile | 96 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range (IQR) | 35 |
Descriptive statistics
| Standard deviation | 22.874568 |
|---|---|
| Coefficient of variation (CV) | 0.35538581 |
| Kurtosis | -0.68272358 |
| Mean | 64.365452 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | -0.41576294 |
| Sum | 1.7843712 × 108 |
| Variance | 523.24587 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 93 | 103607 | 3.6% |
| 100 | 96907 | 3.4% |
| 87 | 60236 | 2.1% |
| 90 | 57587 | 2.0% |
| 89 | 53396 | 1.9% |
| 86 | 47702 | 1.7% |
| 82 | 46793 | 1.6% |
| 81 | 45330 | 1.6% |
| 67 | 45180 | 1.6% |
| 96 | 45111 | 1.6% |
| Other values (90) | 2170401 | |
| (Missing) | 73092 | 2.6% |
| Value | Count | Frequency (%) |
| 1 | 26 | < 0.1% |
| 2 | 121 | < 0.1% |
| 3 | 341 | < 0.1% |
| 4 | 943 | < 0.1% |
| 5 | 1804 | 0.1% |
| 6 | 2408 | |
| 7 | 3457 | |
| 8 | 4182 | |
| 9 | 4758 | |
| 10 | 5601 |
| Value | Count | Frequency (%) |
| 100 | 96907 | |
| 99 | 4306 | 0.2% |
| 98 | 2329 | 0.1% |
| 97 | 29111 | 1.0% |
| 96 | 45111 | |
| 95 | 3342 | 0.1% |
| 94 | 39650 | 1.4% |
| 93 | 103607 | |
| 92 | 23444 | 0.8% |
| 91 | 12828 | 0.5% |
Pressure(in)
Real number (ℝ)
| Distinct | 1068 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 59200 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.472344 |
| Minimum | 0 |
|---|---|
| Maximum | 58.9 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 21.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 27.25 |
| Q1 | 29.31 |
| median | 29.82 |
| Q3 | 30.01 |
| 95-th percentile | 30.21 |
| Maximum | 58.9 |
| Range | 58.9 |
| Interquartile range (IQR) | 0.7 |
Descriptive statistics
| Standard deviation | 1.0452865 |
|---|---|
| Coefficient of variation (CV) | 0.03546669 |
| Kurtosis | 16.723945 |
| Mean | 29.472344 |
| Median Absolute Deviation (MAD) | 0.26 |
| Skewness | -3.2575402 |
| Sum | 82114137 |
| Variance | 1.0926239 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 29.96 | 43668 | 1.5% |
| 29.94 | 43165 | 1.5% |
| 29.99 | 42978 | 1.5% |
| 30.01 | 41736 | 1.5% |
| 30.03 | 41477 | 1.5% |
| 30.04 | 40651 | 1.4% |
| 29.97 | 40395 | 1.4% |
| 30 | 40178 | 1.4% |
| 29.95 | 40084 | 1.4% |
| 29.93 | 39474 | 1.4% |
| Other values (1058) | 2372336 | |
| (Missing) | 59200 | 2.1% |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 0.02 | 1 | |
| 0.3 | 2 | |
| 2.99 | 2 | |
| 3.04 | 2 | |
| 16.72 | 2 | |
| 19.21 | 2 | |
| 19.24 | 2 | |
| 19.37 | 1 | |
| 19.48 | 1 |
| Value | Count | Frequency (%) |
| 58.9 | 1 | < 0.1% |
| 58.16 | 2 | |
| 58.13 | 1 | < 0.1% |
| 58.04 | 2 | |
| 57.74 | 1 | < 0.1% |
| 56.54 | 1 | < 0.1% |
| 56.31 | 1 | < 0.1% |
| 52.76 | 2 | |
| 38.94 | 3 | |
| 32.87 | 1 | < 0.1% |
Visibility(mi)
Real number (ℝ)
| Distinct | 76 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 70546 |
| Missing (%) | 2.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.0993913 |
| Minimum | 0 |
|---|---|
| Maximum | 140 |
| Zeros | 3238 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 21.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 10 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 140 |
| Range | 140 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.7175457 |
|---|---|
| Coefficient of variation (CV) | 0.29865138 |
| Kurtosis | 103.50643 |
| Mean | 9.0993913 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.1133741 |
| Sum | 25248955 |
| Variance | 7.3850549 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10 | 2230276 | |
| 7 | 79649 | 2.8% |
| 9 | 68817 | 2.4% |
| 8 | 55955 | 2.0% |
| 5 | 53933 | 1.9% |
| 6 | 49051 | 1.7% |
| 2 | 46160 | 1.6% |
| 4 | 45437 | 1.6% |
| 3 | 44012 | 1.5% |
| 1 | 38445 | 1.4% |
| Other values (66) | 63061 | 2.2% |
| (Missing) | 70546 | 2.5% |
| Value | Count | Frequency (%) |
| 0 | 3238 | 0.1% |
| 0.06 | 118 | < 0.1% |
| 0.1 | 268 | < 0.1% |
| 0.12 | 726 | < 0.1% |
| 0.19 | 12 | < 0.1% |
| 0.2 | 2870 | 0.1% |
| 0.25 | 11359 | |
| 0.38 | 130 | < 0.1% |
| 0.4 | 25 | < 0.1% |
| 0.5 | 12290 |
| Value | Count | Frequency (%) |
| 140 | 2 | < 0.1% |
| 130 | 1 | < 0.1% |
| 120 | 4 | < 0.1% |
| 111 | 1 | < 0.1% |
| 110 | 1 | < 0.1% |
| 100 | 37 | < 0.1% |
| 90 | 9 | < 0.1% |
| 80 | 186 | |
| 75 | 33 | < 0.1% |
| 70 | 99 |
Wind_Direction
Categorical
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 73775 |
| Missing (%) | 2.6% |
| Memory size | 21.7 MiB |
| CALM | |
|---|---|
| S | 169743 |
| W | 167830 |
| WNW | 145046 |
| NW | 141344 |
| Other values (19) |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 2.7085573 |
| Min length | 1 |
Characters and Unicode
| Total characters | 7506948 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SW |
|---|---|
| 2nd row | Calm |
| 3rd row | Calm |
| 4th row | Calm |
| 5th row | WSW |
Common Values
| Value | Count | Frequency (%) |
| CALM | 433622 | |
| S | 169743 | 6.0% |
| W | 167830 | 5.9% |
| WNW | 145046 | 5.1% |
| NW | 141344 | 5.0% |
| SSW | 137282 | 4.8% |
| WSW | 130734 | 4.6% |
| SW | 128970 | 4.5% |
| SSE | 125516 | 4.4% |
| NNW | 124583 | 4.4% |
| Other values (14) | 1066897 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| calm | 510156 | |
| s | 169743 | 6.1% |
| w | 167830 | 6.1% |
| wnw | 145046 | 5.2% |
| nw | 141344 | 5.1% |
| ssw | 137282 | 5.0% |
| wsw | 130734 | 4.7% |
| sw | 128970 | 4.7% |
| sse | 125516 | 4.5% |
| nnw | 124583 | 4.5% |
| Other values (13) | 990363 |
Most occurring characters
| Value | Count | Frequency (%) |
| W | 1290808 | |
| S | 1206342 | |
| N | 1046938 | |
| E | 950572 | |
| A | 537804 | |
| C | 510156 | 6.8% |
| L | 433622 | 5.8% |
| M | 433622 | 5.8% |
| a | 144111 | 1.9% |
| t | 135911 | 1.8% |
| Other values (12) | 817062 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 6640457 | |
| Lowercase Letter | 866491 | 11.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 144111 | |
| t | 135911 | |
| l | 98763 | |
| m | 76534 | |
| o | 73553 | |
| h | 73553 | |
| s | 62358 | |
| e | 61468 | |
| r | 56607 | 6.5% |
| u | 39175 | 4.5% |
| Other values (2) | 44458 | 5.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 1290808 | |
| S | 1206342 | |
| N | 1046938 | |
| E | 950572 | |
| A | 537804 | |
| C | 510156 | 7.7% |
| L | 433622 | 6.5% |
| M | 433622 | 6.5% |
| V | 126411 | 1.9% |
| R | 104182 | 1.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7506948 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| W | 1290808 | |
| S | 1206342 | |
| N | 1046938 | |
| E | 950572 | |
| A | 537804 | |
| C | 510156 | 6.8% |
| L | 433622 | 5.8% |
| M | 433622 | 5.8% |
| a | 144111 | 1.9% |
| t | 135911 | 1.8% |
| Other values (12) | 817062 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7506948 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| W | 1290808 | |
| S | 1206342 | |
| N | 1046938 | |
| E | 950572 | |
| A | 537804 | |
| C | 510156 | 6.8% |
| L | 433622 | 5.8% |
| M | 433622 | 5.8% |
| a | 144111 | 1.9% |
| t | 135911 | 1.8% |
| Other values (12) | 817062 |
Wind_Speed(mph)
Real number (ℝ)
MISSING ZEROS
| Distinct | 136 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 157944 |
| Missing (%) | 5.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.3950442 |
| Minimum | 0 |
|---|---|
| Maximum | 1087 |
| Zeros | 433636 |
| Zeros (%) | 15.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 21.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3.5 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 17 |
| Maximum | 1087 |
| Range | 1087 |
| Interquartile range (IQR) | 6.5 |
Descriptive statistics
| Standard deviation | 5.527454 |
|---|---|
| Coefficient of variation (CV) | 0.74745381 |
| Kurtosis | 1508.0314 |
| Mean | 7.3950442 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 10.249727 |
| Sum | 19873427 |
| Variance | 30.552747 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 433636 | |
| 5 | 231000 | 8.1% |
| 3 | 225664 | 7.9% |
| 6 | 222502 | 7.8% |
| 7 | 205667 | 7.2% |
| 8 | 184037 | 6.5% |
| 9 | 165127 | 5.8% |
| 10 | 135850 | 4.8% |
| 12 | 117003 | 4.1% |
| 13 | 88872 | 3.1% |
| Other values (126) | 678040 | |
| (Missing) | 157944 | 5.6% |
| Value | Count | Frequency (%) |
| 0 | 433636 | |
| 1 | 58 | < 0.1% |
| 1.2 | 116 | < 0.1% |
| 2 | 150 | < 0.1% |
| 2.3 | 251 | < 0.1% |
| 3 | 225664 | |
| 3.5 | 42429 | 1.5% |
| 4.6 | 44989 | 1.6% |
| 5 | 231000 | |
| 5.8 | 45427 | 1.6% |
| Value | Count | Frequency (%) |
| 1087 | 1 | |
| 984 | 1 | |
| 822.8 | 2 | |
| 812 | 1 | |
| 518 | 2 | |
| 471.8 | 1 | |
| 245.1 | 1 | |
| 243 | 1 | |
| 232 | 1 | |
| 211 | 1 |
Precipitation(in)
Real number (ℝ)
MISSING SKEWED ZEROS
| Distinct | 230 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 549458 |
| Missing (%) | 19.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0070169399 |
| Minimum | 0 |
|---|---|
| Maximum | 24 |
| Zeros | 2104242 |
| Zeros (%) | 74.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 21.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.02 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.093488312 |
|---|---|
| Coefficient of variation (CV) | 13.323231 |
| Kurtosis | 16665.256 |
| Mean | 0.0070169399 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 106.25894 |
| Sum | 16110.08 |
| Variance | 0.0087400644 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 2104242 | |
| 0.01 | 54160 | 1.9% |
| 0.02 | 26497 | 0.9% |
| 0.03 | 17786 | 0.6% |
| 0.04 | 13745 | 0.5% |
| 0.05 | 10563 | 0.4% |
| 0.06 | 8575 | 0.3% |
| 0.07 | 6868 | 0.2% |
| 0.08 | 5942 | 0.2% |
| 0.09 | 5303 | 0.2% |
| Other values (220) | 42203 | 1.5% |
| (Missing) | 549458 | 19.3% |
| Value | Count | Frequency (%) |
| 0 | 2104242 | |
| 0.01 | 54160 | 1.9% |
| 0.02 | 26497 | 0.9% |
| 0.03 | 17786 | 0.6% |
| 0.04 | 13745 | 0.5% |
| 0.05 | 10563 | 0.4% |
| 0.06 | 8575 | 0.3% |
| 0.07 | 6868 | 0.2% |
| 0.08 | 5942 | 0.2% |
| 0.09 | 5303 | 0.2% |
| Value | Count | Frequency (%) |
| 24 | 5 | < 0.1% |
| 10.4 | 2 | < 0.1% |
| 10.05 | 1 | < 0.1% |
| 10.02 | 3 | < 0.1% |
| 10.01 | 1 | < 0.1% |
| 10 | 15 | < 0.1% |
| 9.99 | 50 | |
| 9.98 | 10 | < 0.1% |
| 9.97 | 9 | < 0.1% |
| 9.96 | 11 | < 0.1% |
Weather_Condition
Categorical
HIGH CARDINALITY IMBALANCE MISSING
| Distinct | 127 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 70636 |
| Missing (%) | 2.5% |
| Memory size | 21.7 MiB |
| Fair | |
|---|---|
| Mostly Cloudy | |
| Cloudy | |
| Partly Cloudy | |
| Clear | |
| Other values (122) |
Length
| Max length | 35 |
|---|---|
| Median length | 30 |
| Mean length | 7.3815903 |
| Min length | 3 |
Characters and Unicode
| Total characters | 20481743 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 16 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Light Rain |
|---|---|
| 2nd row | Light Rain |
| 3rd row | Overcast |
| 4th row | Overcast |
| 5th row | Light Rain |
Common Values
| Value | Count | Frequency (%) |
| Fair | 1107194 | |
| Mostly Cloudy | 363959 | 12.8% |
| Cloudy | 348767 | 12.3% |
| Partly Cloudy | 249939 | 8.8% |
| Clear | 173823 | 6.1% |
| Light Rain | 128403 | 4.5% |
| Overcast | 84882 | 3.0% |
| Scattered Clouds | 45132 | 1.6% |
| Light Snow | 43752 | 1.5% |
| Fog | 41226 | 1.4% |
| Other values (117) | 187629 | 6.6% |
| (Missing) | 70636 | 2.5% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| fair | 1122389 | |
| cloudy | 979677 | |
| mostly | 370256 | 9.8% |
| partly | 253815 | 6.7% |
| light | 193371 | 5.1% |
| rain | 185128 | 4.9% |
| clear | 173823 | 4.6% |
| overcast | 84882 | 2.2% |
| snow | 53748 | 1.4% |
| scattered | 45132 | 1.2% |
| Other values (51) | 328144 | 8.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1926734 | 9.4% |
| l | 1835427 | 9.0% |
| r | 1732864 | 8.5% |
| y | 1676635 | 8.2% |
| i | 1603157 | 7.8% |
| o | 1518576 | 7.4% |
| C | 1198634 | 5.9% |
| F | 1168184 | 5.7% |
| d | 1136664 | 5.5% |
| u | 1046822 | 5.1% |
| Other values (36) | 5638046 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 15675963 | |
| Uppercase Letter | 3735727 | 18.2% |
| Space Separator | 1015659 | 5.0% |
| Other Punctuation | 43608 | 0.2% |
| Dash Punctuation | 10786 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1926734 | |
| l | 1835427 | |
| r | 1732864 | |
| y | 1676635 | |
| i | 1603157 | |
| o | 1518576 | |
| d | 1136664 | |
| u | 1046822 | |
| t | 1035948 | |
| s | 508898 | 3.2% |
| Other values (15) | 1654238 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 1198634 | |
| F | 1168184 | |
| M | 375193 | 10.0% |
| P | 256084 | 6.9% |
| L | 193372 | 5.2% |
| R | 185128 | 5.0% |
| S | 119203 | 3.2% |
| O | 84882 | 2.3% |
| H | 55817 | 1.5% |
| W | 46515 | 1.2% |
| Other values (8) | 52715 | 1.4% |
Space Separator
| Value | Count | Frequency (%) |
| 1015659 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 43608 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 10786 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 19411690 | |
| Common | 1070053 | 5.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 1926734 | |
| l | 1835427 | |
| r | 1732864 | 8.9% |
| y | 1676635 | 8.6% |
| i | 1603157 | 8.3% |
| o | 1518576 | 7.8% |
| C | 1198634 | 6.2% |
| F | 1168184 | 6.0% |
| d | 1136664 | 5.9% |
| u | 1046822 | 5.4% |
| Other values (33) | 4567993 |
Common
| Value | Count | Frequency (%) |
| 1015659 | ||
| / | 43608 | 4.1% |
| - | 10786 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 20481743 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 1926734 | 9.4% |
| l | 1835427 | 9.0% |
| r | 1732864 | 8.5% |
| y | 1676635 | 8.2% |
| i | 1603157 | 7.8% |
| o | 1518576 | 7.4% |
| C | 1198634 | 5.9% |
| F | 1168184 | 5.7% |
| d | 1136664 | 5.5% |
| u | 1046822 | 5.1% |
| Other values (36) | 5638046 |
Amenity
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| False | |
|---|---|
| True | 27990 |
| Value | Count | Frequency (%) |
| False | 2817352 | |
| True | 27990 | 1.0% |
Bump
Boolean
HIGH CORRELATION IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| False | |
|---|---|
| True | 1021 |
| Value | Count | Frequency (%) |
| False | 2844321 | |
| True | 1021 | < 0.1% |
Crossing
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| False | |
|---|---|
| True | 200212 |
| Value | Count | Frequency (%) |
| False | 2645130 | |
| True | 200212 | 7.0% |
Give_Way
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| False | |
|---|---|
| True | 6868 |
| Value | Count | Frequency (%) |
| False | 2838474 | |
| True | 6868 | 0.2% |
Junction
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 2554837 | |
| True | 290505 | 10.2% |
No_Exit
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| False | |
|---|---|
| True | 4294 |
| Value | Count | Frequency (%) |
| False | 2841048 | |
| True | 4294 | 0.2% |
Railway
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| False | |
|---|---|
| True | 22631 |
| Value | Count | Frequency (%) |
| False | 2822711 | |
| True | 22631 | 0.8% |
Roundabout
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| False | |
|---|---|
| True | 123 |
| Value | Count | Frequency (%) |
| False | 2845219 | |
| True | 123 | < 0.1% |
Station
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| False | |
|---|---|
| True | 67995 |
| Value | Count | Frequency (%) |
| False | 2777347 | |
| True | 67995 | 2.4% |
Stop
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| False | |
|---|---|
| True | 50400 |
| Value | Count | Frequency (%) |
| False | 2794942 | |
| True | 50400 | 1.8% |
Traffic_Calming
Boolean
HIGH CORRELATION IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| False | |
|---|---|
| True | 1712 |
| Value | Count | Frequency (%) |
| False | 2843630 | |
| True | 1712 | 0.1% |
Traffic_Signal
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 2580079 | |
| True | 265263 | 9.3% |
Turning_Loop
Boolean
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 2845342 |
Sunrise_Sunset
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2867 |
| Missing (%) | 0.1% |
| Memory size | 21.7 MiB |
| Day | |
|---|---|
| Night |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.7251005 |
| Min length | 3 |
Characters and Unicode
| Total characters | 10588505 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Night |
|---|---|
| 2nd row | Night |
| 3rd row | Night |
| 4th row | Night |
| 5th row | Day |
Common Values
| Value | Count | Frequency (%) |
| Day | 1811935 | |
| Night | 1030540 | |
| (Missing) | 2867 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| day | 1811935 | |
| night | 1030540 |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 1811935 | |
| a | 1811935 | |
| y | 1811935 | |
| N | 1030540 | |
| i | 1030540 | |
| g | 1030540 | |
| h | 1030540 | |
| t | 1030540 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7746030 | |
| Uppercase Letter | 2842475 | 26.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1811935 | |
| y | 1811935 | |
| i | 1030540 | |
| g | 1030540 | |
| h | 1030540 | |
| t | 1030540 |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 1811935 | |
| N | 1030540 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10588505 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 1811935 | |
| a | 1811935 | |
| y | 1811935 | |
| N | 1030540 | |
| i | 1030540 | |
| g | 1030540 | |
| h | 1030540 | |
| t | 1030540 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10588505 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 1811935 | |
| a | 1811935 | |
| y | 1811935 | |
| N | 1030540 | |
| i | 1030540 | |
| g | 1030540 | |
| h | 1030540 | |
| t | 1030540 |
Civil_Twilight
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2867 |
| Missing (%) | 0.1% |
| Memory size | 21.7 MiB |
| Day | |
|---|---|
| Night |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.6426597 |
| Min length | 3 |
Characters and Unicode
| Total characters | 10354169 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Night |
|---|---|
| 2nd row | Night |
| 3rd row | Night |
| 4th row | Night |
| 5th row | Day |
Common Values
| Value | Count | Frequency (%) |
| Day | 1929103 | |
| Night | 913372 | |
| (Missing) | 2867 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| day | 1929103 | |
| night | 913372 |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 1929103 | |
| a | 1929103 | |
| y | 1929103 | |
| N | 913372 | |
| i | 913372 | |
| g | 913372 | |
| h | 913372 | |
| t | 913372 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7511694 | |
| Uppercase Letter | 2842475 | 27.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1929103 | |
| y | 1929103 | |
| i | 913372 | |
| g | 913372 | |
| h | 913372 | |
| t | 913372 |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 1929103 | |
| N | 913372 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10354169 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 1929103 | |
| a | 1929103 | |
| y | 1929103 | |
| N | 913372 | |
| i | 913372 | |
| g | 913372 | |
| h | 913372 | |
| t | 913372 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10354169 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 1929103 | |
| a | 1929103 | |
| y | 1929103 | |
| N | 913372 | |
| i | 913372 | |
| g | 913372 | |
| h | 913372 | |
| t | 913372 |
Nautical_Twilight
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2867 |
| Missing (%) | 0.1% |
| Memory size | 21.7 MiB |
| Day | |
|---|---|
| Night |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.548116 |
| Min length | 3 |
Characters and Unicode
| Total characters | 10085431 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Night |
|---|---|
| 2nd row | Night |
| 3rd row | Night |
| 4th row | Day |
| 5th row | Day |
Common Values
| Value | Count | Frequency (%) |
| Day | 2063472 | |
| Night | 779003 | 27.4% |
| (Missing) | 2867 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| day | 2063472 | |
| night | 779003 | 27.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 2063472 | |
| a | 2063472 | |
| y | 2063472 | |
| N | 779003 | 7.7% |
| i | 779003 | 7.7% |
| g | 779003 | 7.7% |
| h | 779003 | 7.7% |
| t | 779003 | 7.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7242956 | |
| Uppercase Letter | 2842475 | 28.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 2063472 | |
| y | 2063472 | |
| i | 779003 | 10.8% |
| g | 779003 | 10.8% |
| h | 779003 | 10.8% |
| t | 779003 | 10.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 2063472 | |
| N | 779003 | 27.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10085431 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 2063472 | |
| a | 2063472 | |
| y | 2063472 | |
| N | 779003 | 7.7% |
| i | 779003 | 7.7% |
| g | 779003 | 7.7% |
| h | 779003 | 7.7% |
| t | 779003 | 7.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10085431 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 2063472 | |
| a | 2063472 | |
| y | 2063472 | |
| N | 779003 | 7.7% |
| i | 779003 | 7.7% |
| g | 779003 | 7.7% |
| h | 779003 | 7.7% |
| t | 779003 | 7.7% |
Astronomical_Twilight
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2867 |
| Missing (%) | 0.1% |
| Memory size | 21.7 MiB |
| Day | |
|---|---|
| Night |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.4682483 |
| Min length | 3 |
Characters and Unicode
| Total characters | 9858409 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Night |
|---|---|
| 2nd row | Night |
| 3rd row | Day |
| 4th row | Day |
| 5th row | Day |
Common Values
| Value | Count | Frequency (%) |
| Day | 2176983 | |
| Night | 665492 | 23.4% |
| (Missing) | 2867 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| day | 2176983 | |
| night | 665492 | 23.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 2176983 | |
| a | 2176983 | |
| y | 2176983 | |
| N | 665492 | 6.8% |
| i | 665492 | 6.8% |
| g | 665492 | 6.8% |
| h | 665492 | 6.8% |
| t | 665492 | 6.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7015934 | |
| Uppercase Letter | 2842475 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 2176983 | |
| y | 2176983 | |
| i | 665492 | 9.5% |
| g | 665492 | 9.5% |
| h | 665492 | 9.5% |
| t | 665492 | 9.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 2176983 | |
| N | 665492 | 23.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9858409 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 2176983 | |
| a | 2176983 | |
| y | 2176983 | |
| N | 665492 | 6.8% |
| i | 665492 | 6.8% |
| g | 665492 | 6.8% |
| h | 665492 | 6.8% |
| t | 665492 | 6.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9858409 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 2176983 | |
| a | 2176983 | |
| y | 2176983 | |
| N | 665492 | 6.8% |
| i | 665492 | 6.8% |
| g | 665492 | 6.8% |
| h | 665492 | 6.8% |
| t | 665492 | 6.8% |
traffic_event_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 21.7 MiB |
| Accident | |
|---|---|
| Incident | |
| Cautionary events | 99666 |
Length
| Max length | 17 |
|---|---|
| Median length | 8 |
| Mean length | 8.31525 |
| Min length | 8 |
Characters and Unicode
| Total characters | 23659730 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Accident |
|---|---|
| 2nd row | Accident |
| 3rd row | Accident |
| 4th row | Accident |
| 5th row | Accident |
Common Values
| Value | Count | Frequency (%) |
| Accident | 1889425 | |
| Incident | 856251 | |
| Cautionary events | 99666 | 3.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| accident | 1889425 | |
| incident | 856251 | |
| cautionary | 99666 | 3.4% |
| events | 99666 | 3.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 4635101 | |
| n | 3801259 | |
| e | 2945008 | |
| t | 2945008 | |
| i | 2845342 | |
| d | 2745676 | |
| A | 1889425 | |
| I | 856251 | 3.6% |
| a | 199332 | 0.8% |
| y | 99666 | 0.4% |
| Other values (7) | 697662 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 20714722 | |
| Uppercase Letter | 2845342 | 12.0% |
| Space Separator | 99666 | 0.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 4635101 | |
| n | 3801259 | |
| e | 2945008 | |
| t | 2945008 | |
| i | 2845342 | |
| d | 2745676 | |
| a | 199332 | 1.0% |
| y | 99666 | 0.5% |
| v | 99666 | 0.5% |
| r | 99666 | 0.5% |
| Other values (3) | 298998 | 1.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 1889425 | |
| I | 856251 | |
| C | 99666 | 3.5% |
Space Separator
| Value | Count | Frequency (%) |
| 99666 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 23560064 | |
| Common | 99666 | 0.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| c | 4635101 | |
| n | 3801259 | |
| e | 2945008 | |
| t | 2945008 | |
| i | 2845342 | |
| d | 2745676 | |
| A | 1889425 | |
| I | 856251 | 3.6% |
| a | 199332 | 0.8% |
| y | 99666 | 0.4% |
| Other values (6) | 597996 | 2.5% |
Common
| Value | Count | Frequency (%) |
| 99666 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 23659730 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| c | 4635101 | |
| n | 3801259 | |
| e | 2945008 | |
| t | 2945008 | |
| i | 2845342 | |
| d | 2745676 | |
| A | 1889425 | |
| I | 856251 | 3.6% |
| a | 199332 | 0.8% |
| y | 99666 | 0.4% |
| Other values (7) | 697662 | 2.9% |
traffic_event_type_ext
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 21.7 MiB |
| Accident | |
|---|---|
| Incident | |
| Cautionary events | 99491 |
| Rollover | 198 |
Length
| Max length | 17 |
|---|---|
| Median length | 8 |
| Mean length | 8.3146964 |
| Min length | 8 |
Characters and Unicode
| Total characters | 23658155 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Accident |
|---|---|
| 2nd row | Accident |
| 3rd row | Accident |
| 4th row | Accident |
| 5th row | Accident |
Common Values
| Value | Count | Frequency (%) |
| Accident | 1889402 | |
| Incident | 856251 | |
| Cautionary events | 99491 | 3.5% |
| Rollover | 198 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| accident | 1889402 | |
| incident | 856251 | |
| cautionary | 99491 | 3.4% |
| events | 99491 | 3.4% |
| rollover | 198 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 4635055 | |
| n | 3800886 | |
| e | 2944833 | |
| t | 2944635 | |
| i | 2845144 | |
| d | 2745653 | |
| A | 1889402 | |
| I | 856251 | 3.6% |
| a | 198982 | 0.8% |
| o | 99887 | 0.4% |
| Other values (9) | 697427 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 20713322 | |
| Uppercase Letter | 2845342 | 12.0% |
| Space Separator | 99491 | 0.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 4635055 | |
| n | 3800886 | |
| e | 2944833 | |
| t | 2944635 | |
| i | 2845144 | |
| d | 2745653 | |
| a | 198982 | 1.0% |
| o | 99887 | 0.5% |
| r | 99689 | 0.5% |
| v | 99689 | 0.5% |
| Other values (4) | 298869 | 1.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 1889402 | |
| I | 856251 | |
| C | 99491 | 3.5% |
| R | 198 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 99491 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 23558664 | |
| Common | 99491 | 0.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| c | 4635055 | |
| n | 3800886 | |
| e | 2944833 | |
| t | 2944635 | |
| i | 2845144 | |
| d | 2745653 | |
| A | 1889402 | |
| I | 856251 | 3.6% |
| a | 198982 | 0.8% |
| o | 99887 | 0.4% |
| Other values (8) | 597936 | 2.5% |
Common
| Value | Count | Frequency (%) |
| 99491 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 23658155 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| c | 4635055 | |
| n | 3800886 | |
| e | 2944833 | |
| t | 2944635 | |
| i | 2845144 | |
| d | 2745653 | |
| A | 1889402 | |
| I | 856251 | 3.6% |
| a | 198982 | 0.8% |
| o | 99887 | 0.4% |
| Other values (9) | 697427 | 2.9% |
date
Unsupported
REJECTED UNSUPPORTED
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 21.7 MiB |
| Start_Lat | Start_Lng | End_Lat | End_Lng | Distance(mi) | Number | Temperature(F) | Wind_Chill(F) | Humidity(%) | Pressure(in) | Visibility(mi) | Wind_Speed(mph) | Precipitation(in) | Severity | Side | State | Timezone | Wind_Direction | Amenity | Bump | Crossing | Give_Way | Junction | No_Exit | Railway | Roundabout | Station | Stop | Traffic_Calming | Traffic_Signal | Sunrise_Sunset | Civil_Twilight | Nautical_Twilight | Astronomical_Twilight | traffic_event_type | traffic_event_type_ext | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Start_Lat | 1.000 | -0.059 | 1.000 | -0.059 | 0.077 | -0.057 | -0.460 | -0.490 | 0.020 | -0.240 | -0.091 | 0.029 | 0.064 | 0.096 | 0.100 | 0.738 | 0.456 | 0.118 | 0.041 | 0.012 | 0.145 | 0.029 | 0.084 | 0.031 | 0.020 | 0.007 | 0.171 | 0.042 | 0.013 | 0.076 | 0.051 | 0.046 | 0.039 | 0.041 | 0.146 | 0.120 |
| Start_Lng | -0.059 | 1.000 | -0.059 | 1.000 | 0.133 | -0.227 | 0.063 | 0.052 | 0.101 | 0.146 | 0.067 | 0.086 | 0.022 | 0.149 | 0.087 | 0.853 | 0.947 | 0.115 | 0.032 | 0.029 | 0.136 | 0.035 | 0.069 | 0.025 | 0.026 | 0.003 | 0.104 | 0.065 | 0.022 | 0.098 | 0.047 | 0.044 | 0.037 | 0.034 | 0.155 | 0.127 |
| End_Lat | 1.000 | -0.059 | 1.000 | -0.059 | 0.077 | -0.057 | -0.460 | -0.490 | 0.020 | -0.240 | -0.091 | 0.029 | 0.064 | 0.095 | 0.101 | 0.736 | 0.454 | 0.118 | 0.041 | 0.012 | 0.145 | 0.029 | 0.083 | 0.031 | 0.020 | 0.007 | 0.171 | 0.042 | 0.013 | 0.076 | 0.051 | 0.045 | 0.039 | 0.040 | 0.147 | 0.120 |
| End_Lng | -0.059 | 1.000 | -0.059 | 1.000 | 0.133 | -0.227 | 0.063 | 0.052 | 0.101 | 0.146 | 0.067 | 0.086 | 0.022 | 0.149 | 0.087 | 0.853 | 0.947 | 0.115 | 0.032 | 0.029 | 0.136 | 0.035 | 0.070 | 0.025 | 0.026 | 0.003 | 0.104 | 0.065 | 0.022 | 0.098 | 0.047 | 0.044 | 0.037 | 0.034 | 0.155 | 0.127 |
| Distance(mi) | 0.077 | 0.133 | 0.077 | 0.133 | 1.000 | 0.097 | -0.036 | -0.046 | 0.048 | -0.008 | -0.029 | 0.012 | 0.025 | 0.026 | 0.004 | 0.033 | 0.017 | 0.004 | 0.002 | 0.000 | 0.007 | 0.000 | 0.001 | 0.000 | 0.001 | 0.000 | 0.005 | 0.001 | 0.000 | 0.008 | 0.006 | 0.006 | 0.005 | 0.006 | 0.004 | 0.003 |
| Number | -0.057 | -0.227 | -0.057 | -0.227 | 0.097 | 1.000 | 0.035 | 0.043 | 0.003 | 0.041 | -0.007 | 0.012 | 0.006 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Temperature(F) | -0.460 | 0.063 | -0.460 | 0.063 | -0.036 | 0.035 | 1.000 | 0.999 | -0.364 | 0.058 | 0.220 | 0.140 | -0.113 | 0.036 | 0.041 | 0.188 | 0.131 | 0.075 | 0.013 | 0.004 | 0.060 | 0.005 | 0.020 | 0.013 | 0.009 | 0.002 | 0.053 | 0.008 | 0.005 | 0.041 | 0.334 | 0.315 | 0.294 | 0.276 | 0.095 | 0.078 |
| Wind_Chill(F) | -0.490 | 0.052 | -0.490 | 0.052 | -0.046 | 0.043 | 0.999 | 1.000 | -0.355 | 0.061 | 0.221 | 0.108 | -0.118 | 0.061 | 0.058 | 0.207 | 0.156 | 0.110 | 0.017 | 0.006 | 0.070 | 0.007 | 0.044 | 0.014 | 0.011 | 0.002 | 0.063 | 0.013 | 0.007 | 0.046 | 0.336 | 0.317 | 0.296 | 0.279 | 0.089 | 0.073 |
| Humidity(%) | 0.020 | 0.101 | 0.020 | 0.101 | 0.048 | 0.003 | -0.364 | -0.355 | 1.000 | 0.089 | -0.438 | -0.203 | 0.347 | 0.061 | 0.022 | 0.149 | 0.199 | 0.090 | 0.015 | 0.010 | 0.039 | 0.005 | 0.011 | 0.010 | 0.005 | 0.000 | 0.043 | 0.022 | 0.007 | 0.039 | 0.312 | 0.295 | 0.279 | 0.261 | 0.069 | 0.057 |
| Pressure(in) | -0.240 | 0.146 | -0.240 | 0.146 | -0.008 | 0.041 | 0.058 | 0.061 | 0.089 | 1.000 | 0.072 | -0.005 | -0.017 | 0.040 | 0.018 | 0.227 | 0.211 | 0.083 | 0.017 | 0.003 | 0.028 | 0.004 | 0.041 | 0.001 | 0.018 | 0.000 | 0.055 | 0.010 | 0.000 | 0.014 | 0.032 | 0.032 | 0.031 | 0.031 | 0.085 | 0.069 |
| Visibility(mi) | -0.091 | 0.067 | -0.091 | 0.067 | -0.029 | -0.007 | 0.220 | 0.221 | -0.438 | 0.072 | 1.000 | 0.080 | -0.408 | 0.031 | 0.011 | 0.092 | 0.074 | 0.015 | 0.003 | 0.000 | 0.004 | 0.010 | 0.008 | 0.007 | 0.004 | 0.000 | 0.007 | 0.000 | 0.000 | 0.004 | 0.017 | 0.018 | 0.018 | 0.017 | 0.018 | 0.014 |
| Wind_Speed(mph) | 0.029 | 0.086 | 0.029 | 0.086 | 0.012 | 0.012 | 0.140 | 0.108 | -0.203 | -0.005 | 0.080 | 1.000 | 0.081 | 0.002 | 0.000 | 0.000 | 0.000 | 0.002 | 0.000 | 0.000 | 0.001 | 0.000 | 0.001 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.001 | 0.002 | 0.002 | 0.002 | 0.002 | 0.000 | 0.000 |
| Precipitation(in) | 0.064 | 0.022 | 0.064 | 0.022 | 0.025 | 0.006 | -0.113 | -0.118 | 0.347 | -0.017 | -0.408 | 0.081 | 1.000 | 0.004 | 0.002 | 0.014 | 0.005 | 0.034 | 0.005 | 0.000 | 0.003 | 0.000 | 0.006 | 0.000 | 0.001 | 0.000 | 0.000 | 0.000 | 0.000 | 0.005 | 0.002 | 0.002 | 0.003 | 0.003 | 0.004 | 0.003 |
| Severity | 0.096 | 0.149 | 0.095 | 0.149 | 0.026 | 0.000 | 0.036 | 0.061 | 0.061 | 0.040 | 0.031 | 0.002 | 0.004 | 1.000 | 0.044 | 0.232 | 0.112 | 0.141 | 0.013 | 0.004 | 0.100 | 0.012 | 0.079 | 0.012 | 0.014 | 0.001 | 0.019 | 0.018 | 0.003 | 0.122 | 0.052 | 0.053 | 0.052 | 0.051 | 0.146 | 0.120 |
| Side | 0.100 | 0.087 | 0.101 | 0.087 | 0.004 | 0.000 | 0.041 | 0.058 | 0.022 | 0.018 | 0.011 | 0.000 | 0.002 | 0.044 | 1.000 | 0.116 | 0.057 | 0.062 | 0.051 | 0.006 | 0.103 | 0.000 | 0.144 | 0.011 | 0.016 | 0.003 | 0.081 | 0.053 | 0.005 | 0.092 | 0.010 | 0.008 | 0.006 | 0.006 | 0.049 | 0.049 |
| State | 0.738 | 0.853 | 0.736 | 0.853 | 0.033 | 0.000 | 0.188 | 0.207 | 0.149 | 0.227 | 0.092 | 0.000 | 0.014 | 0.232 | 0.116 | 1.000 | 0.970 | 0.096 | 0.072 | 0.039 | 0.205 | 0.057 | 0.132 | 0.041 | 0.056 | 0.008 | 0.157 | 0.106 | 0.033 | 0.164 | 0.078 | 0.076 | 0.071 | 0.069 | 0.270 | 0.221 |
| Timezone | 0.456 | 0.947 | 0.454 | 0.947 | 0.017 | 0.000 | 0.131 | 0.156 | 0.199 | 0.211 | 0.074 | 0.000 | 0.005 | 0.112 | 0.057 | 0.970 | 1.000 | 0.139 | 0.015 | 0.021 | 0.098 | 0.022 | 0.047 | 0.020 | 0.023 | 0.001 | 0.056 | 0.041 | 0.013 | 0.075 | 0.032 | 0.030 | 0.023 | 0.020 | 0.130 | 0.107 |
| Wind_Direction | 0.118 | 0.115 | 0.118 | 0.115 | 0.004 | 0.000 | 0.075 | 0.110 | 0.090 | 0.083 | 0.015 | 0.002 | 0.034 | 0.141 | 0.062 | 0.096 | 0.139 | 1.000 | 0.017 | 0.005 | 0.053 | 0.004 | 0.102 | 0.009 | 0.005 | 0.002 | 0.050 | 0.023 | 0.006 | 0.031 | 0.221 | 0.216 | 0.207 | 0.196 | 0.171 | 0.140 |
| Amenity | 0.041 | 0.032 | 0.041 | 0.032 | 0.002 | 0.000 | 0.013 | 0.017 | 0.015 | 0.017 | 0.003 | 0.000 | 0.005 | 0.013 | 0.051 | 0.072 | 0.015 | 0.017 | 1.000 | 0.005 | 0.118 | 0.003 | 0.026 | 0.013 | 0.034 | 0.000 | 0.124 | 0.027 | 0.011 | 0.091 | 0.006 | 0.005 | 0.003 | 0.003 | 0.006 | 0.006 |
| Bump | 0.012 | 0.029 | 0.012 | 0.029 | 0.000 | 0.000 | 0.004 | 0.006 | 0.010 | 0.003 | 0.000 | 0.000 | 0.000 | 0.004 | 0.006 | 0.039 | 0.021 | 0.005 | 0.005 | 1.000 | 0.013 | 0.000 | 0.002 | 0.002 | 0.006 | 0.000 | 0.006 | 0.019 | 0.772 | 0.004 | 0.002 | 0.002 | 0.002 | 0.002 | 0.008 | 0.008 |
| Crossing | 0.145 | 0.136 | 0.145 | 0.136 | 0.007 | 0.000 | 0.060 | 0.070 | 0.039 | 0.028 | 0.004 | 0.001 | 0.003 | 0.100 | 0.103 | 0.205 | 0.098 | 0.053 | 0.118 | 0.013 | 1.000 | 0.053 | 0.080 | 0.042 | 0.207 | 0.000 | 0.145 | 0.087 | 0.026 | 0.422 | 0.022 | 0.019 | 0.016 | 0.013 | 0.028 | 0.028 |
| Give_Way | 0.029 | 0.035 | 0.029 | 0.035 | 0.000 | 0.000 | 0.005 | 0.007 | 0.005 | 0.004 | 0.010 | 0.000 | 0.000 | 0.012 | 0.000 | 0.057 | 0.022 | 0.004 | 0.003 | 0.000 | 0.053 | 1.000 | 0.007 | 0.004 | 0.004 | 0.002 | 0.002 | 0.048 | 0.000 | 0.057 | 0.000 | 0.000 | 0.000 | 0.000 | 0.007 | 0.007 |
| Junction | 0.084 | 0.069 | 0.083 | 0.070 | 0.001 | 0.000 | 0.020 | 0.044 | 0.011 | 0.041 | 0.008 | 0.001 | 0.006 | 0.079 | 0.144 | 0.132 | 0.047 | 0.102 | 0.026 | 0.002 | 0.080 | 0.007 | 1.000 | 0.004 | 0.010 | 0.012 | 0.044 | 0.035 | 0.002 | 0.096 | 0.005 | 0.006 | 0.008 | 0.008 | 0.085 | 0.085 |
| No_Exit | 0.031 | 0.025 | 0.031 | 0.025 | 0.000 | 0.000 | 0.013 | 0.014 | 0.010 | 0.001 | 0.007 | 0.000 | 0.000 | 0.012 | 0.011 | 0.041 | 0.020 | 0.009 | 0.013 | 0.002 | 0.042 | 0.004 | 0.004 | 1.000 | 0.003 | 0.000 | 0.015 | 0.012 | 0.001 | 0.023 | 0.001 | 0.000 | 0.000 | 0.000 | 0.002 | 0.002 |
| Railway | 0.020 | 0.026 | 0.020 | 0.026 | 0.001 | 0.000 | 0.009 | 0.011 | 0.005 | 0.018 | 0.004 | 0.000 | 0.001 | 0.014 | 0.016 | 0.056 | 0.023 | 0.005 | 0.034 | 0.006 | 0.207 | 0.004 | 0.010 | 0.003 | 1.000 | 0.000 | 0.109 | 0.008 | 0.005 | 0.054 | 0.001 | 0.001 | 0.001 | 0.001 | 0.002 | 0.002 |
| Roundabout | 0.007 | 0.003 | 0.007 | 0.003 | 0.000 | 0.000 | 0.002 | 0.002 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.001 | 0.003 | 0.008 | 0.001 | 0.002 | 0.000 | 0.000 | 0.000 | 0.002 | 0.012 | 0.000 | 0.000 | 1.000 | 0.000 | 0.006 | 0.001 | 0.002 | 0.000 | 0.000 | 0.000 | 0.001 | 0.006 | 0.006 |
| Station | 0.171 | 0.104 | 0.171 | 0.104 | 0.005 | 0.000 | 0.053 | 0.063 | 0.043 | 0.055 | 0.007 | 0.000 | 0.000 | 0.019 | 0.081 | 0.157 | 0.056 | 0.050 | 0.124 | 0.006 | 0.145 | 0.002 | 0.044 | 0.015 | 0.109 | 0.000 | 1.000 | 0.027 | 0.010 | 0.113 | 0.020 | 0.019 | 0.016 | 0.016 | 0.023 | 0.023 |
| Stop | 0.042 | 0.065 | 0.042 | 0.065 | 0.001 | 0.000 | 0.008 | 0.013 | 0.022 | 0.010 | 0.000 | 0.000 | 0.000 | 0.018 | 0.053 | 0.106 | 0.041 | 0.023 | 0.027 | 0.019 | 0.087 | 0.048 | 0.035 | 0.012 | 0.008 | 0.006 | 0.027 | 1.000 | 0.017 | 0.028 | 0.010 | 0.011 | 0.012 | 0.012 | 0.045 | 0.045 |
| Traffic_Calming | 0.013 | 0.022 | 0.013 | 0.022 | 0.000 | 0.000 | 0.005 | 0.007 | 0.007 | 0.000 | 0.000 | 0.000 | 0.000 | 0.003 | 0.005 | 0.033 | 0.013 | 0.006 | 0.011 | 0.772 | 0.026 | 0.000 | 0.002 | 0.001 | 0.005 | 0.001 | 0.010 | 0.017 | 1.000 | 0.009 | 0.001 | 0.001 | 0.002 | 0.001 | 0.007 | 0.007 |
| Traffic_Signal | 0.076 | 0.098 | 0.076 | 0.098 | 0.008 | 0.000 | 0.041 | 0.046 | 0.039 | 0.014 | 0.004 | 0.001 | 0.005 | 0.122 | 0.092 | 0.164 | 0.075 | 0.031 | 0.091 | 0.004 | 0.422 | 0.057 | 0.096 | 0.023 | 0.054 | 0.002 | 0.113 | 0.028 | 0.009 | 1.000 | 0.018 | 0.015 | 0.011 | 0.008 | 0.039 | 0.039 |
| Sunrise_Sunset | 0.051 | 0.047 | 0.051 | 0.047 | 0.006 | 0.000 | 0.334 | 0.336 | 0.312 | 0.032 | 0.017 | 0.002 | 0.002 | 0.052 | 0.010 | 0.078 | 0.032 | 0.221 | 0.006 | 0.002 | 0.022 | 0.000 | 0.005 | 0.001 | 0.001 | 0.000 | 0.020 | 0.010 | 0.001 | 0.018 | 1.000 | 0.912 | 0.815 | 0.730 | 0.186 | 0.186 |
| Civil_Twilight | 0.046 | 0.044 | 0.045 | 0.044 | 0.006 | 0.000 | 0.315 | 0.317 | 0.295 | 0.032 | 0.018 | 0.002 | 0.002 | 0.053 | 0.008 | 0.076 | 0.030 | 0.216 | 0.005 | 0.002 | 0.019 | 0.000 | 0.006 | 0.000 | 0.001 | 0.000 | 0.019 | 0.011 | 0.001 | 0.015 | 0.912 | 1.000 | 0.893 | 0.800 | 0.197 | 0.197 |
| Nautical_Twilight | 0.039 | 0.037 | 0.039 | 0.037 | 0.005 | 0.000 | 0.294 | 0.296 | 0.279 | 0.031 | 0.018 | 0.002 | 0.003 | 0.052 | 0.006 | 0.071 | 0.023 | 0.207 | 0.003 | 0.002 | 0.016 | 0.000 | 0.008 | 0.000 | 0.001 | 0.000 | 0.016 | 0.012 | 0.002 | 0.011 | 0.815 | 0.893 | 1.000 | 0.896 | 0.210 | 0.210 |
| Astronomical_Twilight | 0.041 | 0.034 | 0.040 | 0.034 | 0.006 | 0.000 | 0.276 | 0.279 | 0.261 | 0.031 | 0.017 | 0.002 | 0.003 | 0.051 | 0.006 | 0.069 | 0.020 | 0.196 | 0.003 | 0.002 | 0.013 | 0.000 | 0.008 | 0.000 | 0.001 | 0.001 | 0.016 | 0.012 | 0.001 | 0.008 | 0.730 | 0.800 | 0.896 | 1.000 | 0.220 | 0.220 |
| traffic_event_type | 0.146 | 0.155 | 0.147 | 0.155 | 0.004 | 0.000 | 0.095 | 0.089 | 0.069 | 0.085 | 0.018 | 0.000 | 0.004 | 0.146 | 0.049 | 0.270 | 0.130 | 0.171 | 0.006 | 0.008 | 0.028 | 0.007 | 0.085 | 0.002 | 0.002 | 0.006 | 0.023 | 0.045 | 0.007 | 0.039 | 0.186 | 0.197 | 0.210 | 0.220 | 1.000 | 1.000 |
| traffic_event_type_ext | 0.120 | 0.127 | 0.120 | 0.127 | 0.003 | 0.000 | 0.078 | 0.073 | 0.057 | 0.069 | 0.014 | 0.000 | 0.003 | 0.120 | 0.049 | 0.221 | 0.107 | 0.140 | 0.006 | 0.008 | 0.028 | 0.007 | 0.085 | 0.002 | 0.002 | 0.006 | 0.023 | 0.045 | 0.007 | 0.039 | 0.186 | 0.197 | 0.210 | 0.220 | 1.000 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| ID | Severity | Start_Time | End_Time | Start_Lat | Start_Lng | End_Lat | End_Lng | Distance(mi) | Description | Number | Street | Side | City | County | State | Zipcode | Country | Timezone | Airport_Code | Weather_Timestamp | Temperature(F) | Wind_Chill(F) | Humidity(%) | Pressure(in) | Visibility(mi) | Wind_Direction | Wind_Speed(mph) | Precipitation(in) | Weather_Condition | Amenity | Bump | Crossing | Give_Way | Junction | No_Exit | Railway | Roundabout | Station | Stop | Traffic_Calming | Traffic_Signal | Turning_Loop | Sunrise_Sunset | Civil_Twilight | Nautical_Twilight | Astronomical_Twilight | traffic_event_type | traffic_event_type_ext | date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | A-1 | 3 | 2016-02-08 00:37:08 | 2016-02-08 06:37:08 | 40.108910 | -83.092860 | 40.112060 | -83.031870 | 3.230 | Between Sawmill Rd/Exit 20 and OH-315/Olentangy Riv Rd/Exit 22 - Accident. | NaN | Outerbelt E | R | Dublin | Franklin | OH | 43017 | US | US/Eastern | KOSU | 2016-02-08 00:53:00 | 42.1 | 36.1 | 58.0 | 29.76 | 10.0 | SW | 10.4 | 0.00 | Light Rain | False | False | False | False | False | False | False | False | False | False | False | False | False | Night | Night | Night | Night | Accident | Accident | 2016-02-08 |
| 1 | A-2 | 2 | 2016-02-08 05:56:20 | 2016-02-08 11:56:20 | 39.865420 | -84.062800 | 39.865010 | -84.048730 | 0.747 | At OH-4/OH-235/Exit 41 - Accident. | NaN | I-70 E | R | Dayton | Montgomery | OH | 45424 | US | US/Eastern | KFFO | 2016-02-08 05:58:00 | 36.9 | NaN | 91.0 | 29.68 | 10.0 | Calm | NaN | 0.02 | Light Rain | False | False | False | False | False | False | False | False | False | False | False | False | False | Night | Night | Night | Night | Accident | Accident | 2016-02-08 |
| 2 | A-3 | 2 | 2016-02-08 06:15:39 | 2016-02-08 12:15:39 | 39.102660 | -84.524680 | 39.102090 | -84.523960 | 0.055 | At I-71/US-50/Exit 1 - Accident. | NaN | I-75 S | R | Cincinnati | Hamilton | OH | 45203 | US | US/Eastern | KLUK | 2016-02-08 05:53:00 | 36.0 | NaN | 97.0 | 29.70 | 10.0 | Calm | NaN | 0.02 | Overcast | False | False | False | False | True | False | False | False | False | False | False | False | False | Night | Night | Night | Day | Accident | Accident | 2016-02-08 |
| 3 | A-4 | 2 | 2016-02-08 06:51:45 | 2016-02-08 12:51:45 | 41.062130 | -81.537840 | 41.062170 | -81.535470 | 0.123 | At Dart Ave/Exit 21 - Accident. | NaN | I-77 N | R | Akron | Summit | OH | 44311 | US | US/Eastern | KAKR | 2016-02-08 06:54:00 | 39.0 | NaN | 55.0 | 29.65 | 10.0 | Calm | NaN | NaN | Overcast | False | False | False | False | False | False | False | False | False | False | False | False | False | Night | Night | Day | Day | Accident | Accident | 2016-02-08 |
| 4 | A-5 | 3 | 2016-02-08 07:53:43 | 2016-02-08 13:53:43 | 39.172393 | -84.492792 | 39.170476 | -84.501798 | 0.500 | At Mitchell Ave/Exit 6 - Accident. | NaN | I-75 S | R | Cincinnati | Hamilton | OH | 45217 | US | US/Eastern | KLUK | 2016-02-08 07:53:00 | 37.0 | 29.8 | 93.0 | 29.69 | 10.0 | WSW | 10.4 | 0.01 | Light Rain | False | False | False | False | False | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2016-02-08 |
| 5 | A-6 | 2 | 2016-02-08 08:16:57 | 2016-02-08 14:16:57 | 39.063240 | -84.032430 | 39.067310 | -84.058510 | 1.427 | At Dela Palma Rd - Accident. | NaN | State Route 32 | R | Williamsburg | Clermont | OH | 45176 | US | US/Eastern | KI69 | 2016-02-08 08:16:00 | 35.6 | 29.2 | 100.0 | 29.66 | 10.0 | WSW | 8.1 | NaN | Overcast | False | False | False | False | False | False | False | False | False | False | False | True | False | Day | Day | Day | Day | Accident | Accident | 2016-02-08 |
| 6 | A-7 | 2 | 2016-02-08 08:15:41 | 2016-02-08 14:15:41 | 39.775650 | -84.186030 | 39.772750 | -84.188050 | 0.227 | At OH-4/Exit 54 - Accident. | NaN | I-75 S | R | Dayton | Montgomery | OH | 45404 | US | US/Eastern | KFFO | 2016-02-08 08:18:00 | 33.8 | NaN | 100.0 | 29.63 | 3.0 | SW | 2.3 | NaN | Mostly Cloudy | False | False | False | False | False | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2016-02-08 |
| 7 | A-8 | 2 | 2016-02-08 11:51:46 | 2016-02-08 17:51:46 | 41.375310 | -81.820170 | 41.367860 | -81.821740 | 0.521 | At Bagley Rd/Exit 235 - Accident. | NaN | I-71 S | R | Cleveland | Cuyahoga | OH | 44130 | US | US/Eastern | KCLE | 2016-02-08 11:51:00 | 33.1 | 30.0 | 92.0 | 29.63 | 0.5 | SW | 3.5 | 0.08 | Snow | False | False | False | False | True | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2016-02-08 |
| 8 | A-9 | 2 | 2016-02-08 14:19:57 | 2016-02-08 20:19:57 | 40.702247 | -84.075887 | 40.699110 | -84.084293 | 0.491 | At OH-65/Exit 122 - Accident. | NaN | E Hanthorn Rd | R | Lima | Allen | OH | 45806 | US | US/Eastern | KAOH | 2016-02-08 13:53:00 | 39.0 | 31.8 | 70.0 | 29.59 | 10.0 | WNW | 11.5 | NaN | Overcast | False | False | False | False | False | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2016-02-08 |
| 9 | A-10 | 2 | 2016-02-08 15:16:43 | 2016-02-08 21:16:43 | 40.109310 | -82.968490 | 40.110780 | -82.984000 | 0.826 | At I-71/Exit 26 - Accident. | NaN | Outerbelt W | R | Westerville | Franklin | OH | 43081 | US | US/Eastern | KCMH | 2016-02-08 15:12:00 | 32.0 | 28.7 | 100.0 | 29.59 | 0.5 | West | 3.5 | 0.05 | Snow | False | False | False | False | False | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2016-02-08 |
| ID | Severity | Start_Time | End_Time | Start_Lat | Start_Lng | End_Lat | End_Lng | Distance(mi) | Description | Number | Street | Side | City | County | State | Zipcode | Country | Timezone | Airport_Code | Weather_Timestamp | Temperature(F) | Wind_Chill(F) | Humidity(%) | Pressure(in) | Visibility(mi) | Wind_Direction | Wind_Speed(mph) | Precipitation(in) | Weather_Condition | Amenity | Bump | Crossing | Give_Way | Junction | No_Exit | Railway | Roundabout | Station | Stop | Traffic_Calming | Traffic_Signal | Turning_Loop | Sunrise_Sunset | Civil_Twilight | Nautical_Twilight | Astronomical_Twilight | traffic_event_type | traffic_event_type_ext | date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2845332 | A-2845333 | 2 | 2019-08-23 17:42:27 | 2019-08-23 18:11:10 | 34.064460 | -118.003880 | 34.065330 | -117.997150 | 0.390 | At I-605 - Accident. | NaN | I-10 E | R | Baldwin Park | Los Angeles | CA | 91706 | US | US/Pacific | KEMT | 2019-08-23 17:53:00 | 78.0 | 78.0 | 52.0 | 29.69 | 10.0 | VAR | 6.0 | 0.0 | Fair | False | False | False | False | False | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2019-08-23 |
| 2845333 | A-2845334 | 2 | 2019-08-23 17:40:12 | 2019-08-23 18:08:35 | 33.943599 | -117.077880 | 33.943599 | -117.077880 | 0.000 | At Jack Rabbit Trl - Accident. | NaN | CA-60 E | R | Moreno Valley | Riverside | CA | 92555 | US | US/Pacific | KRIV | 2019-08-23 17:58:00 | 88.0 | 88.0 | 32.0 | 28.20 | 10.0 | WNW | 10.0 | 0.0 | Fair | False | False | False | False | False | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2019-08-23 |
| 2845334 | A-2845335 | 2 | 2019-08-23 17:40:12 | 2019-08-23 18:08:35 | 34.261030 | -119.228000 | 34.262390 | -119.230870 | 0.189 | At Telephone Rd/Exit 65 - Accident. | NaN | El Camino Real N | R | Ventura | Ventura | CA | 93003 | US | US/Pacific | KOXR | 2019-08-23 17:51:00 | 73.0 | 73.0 | 68.0 | 29.76 | 10.0 | W | 9.0 | 0.0 | Fair | False | False | False | False | True | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2019-08-23 |
| 2845335 | A-2845336 | 2 | 2019-08-23 17:43:56 | 2019-08-23 18:12:27 | 33.741700 | -117.837090 | 33.739170 | -117.830010 | 0.443 | At CA-55 - Accident. | NaN | Santa Ana Fwy S | R | Tustin | Orange | CA | 92780 | US | US/Pacific | KSNA | 2019-08-23 17:53:00 | 75.0 | 75.0 | 60.0 | 29.74 | 10.0 | SSW | 9.0 | 0.0 | Fair | False | False | False | False | False | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2019-08-23 |
| 2845336 | A-2845337 | 2 | 2019-08-23 18:30:23 | 2019-08-23 18:58:54 | 34.239104 | -118.416176 | 34.239104 | -118.416176 | 0.000 | At Osborne St/Exit 154 - Accident. | NaN | Golden State Fwy N | R | Pacoima | Los Angeles | CA | 91331 | US | US/Pacific | KWHP | 2019-08-23 18:50:00 | 81.0 | 81.0 | 48.0 | 28.78 | 10.0 | ESE | 6.0 | NaN | Fair | False | False | False | False | False | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2019-08-23 |
| 2845337 | A-2845338 | 2 | 2019-08-23 18:03:25 | 2019-08-23 18:32:01 | 34.002480 | -117.379360 | 33.998880 | -117.370940 | 0.543 | At Market St - Accident. | NaN | Pomona Fwy E | R | Riverside | Riverside | CA | 92501 | US | US/Pacific | KRAL | 2019-08-23 17:53:00 | 86.0 | 86.0 | 40.0 | 28.92 | 10.0 | W | 13.0 | 0.0 | Fair | False | False | False | False | False | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2019-08-23 |
| 2845338 | A-2845339 | 2 | 2019-08-23 19:11:30 | 2019-08-23 19:38:23 | 32.766960 | -117.148060 | 32.765550 | -117.153630 | 0.338 | At Camino Del Rio/Mission Center Rd - Accident. | NaN | I-8 W | R | San Diego | San Diego | CA | 92108 | US | US/Pacific | KMYF | 2019-08-23 18:53:00 | 70.0 | 70.0 | 73.0 | 29.39 | 10.0 | SW | 6.0 | 0.0 | Fair | False | False | False | False | False | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2019-08-23 |
| 2845339 | A-2845340 | 2 | 2019-08-23 19:00:21 | 2019-08-23 19:28:49 | 33.775450 | -117.847790 | 33.777400 | -117.857270 | 0.561 | At Glassell St/Grand Ave - Accident. in the right lane. | NaN | Garden Grove Fwy | R | Orange | Orange | CA | 92866 | US | US/Pacific | KSNA | 2019-08-23 18:53:00 | 73.0 | 73.0 | 64.0 | 29.74 | 10.0 | SSW | 10.0 | 0.0 | Partly Cloudy | False | False | False | False | True | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2019-08-23 |
| 2845340 | A-2845341 | 2 | 2019-08-23 19:00:21 | 2019-08-23 19:29:42 | 33.992460 | -118.403020 | 33.983110 | -118.395650 | 0.772 | At CA-90/Marina Fwy/Jefferson Blvd - Accident. | NaN | San Diego Fwy S | R | Culver City | Los Angeles | CA | 90230 | US | US/Pacific | KSMO | 2019-08-23 18:51:00 | 71.0 | 71.0 | 81.0 | 29.62 | 10.0 | SW | 8.0 | 0.0 | Fair | False | False | False | False | False | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2019-08-23 |
| 2845341 | A-2845342 | 2 | 2019-08-23 18:52:06 | 2019-08-23 19:21:31 | 34.133930 | -117.230920 | 34.137360 | -117.239340 | 0.537 | At Highland Ave/Arden Ave - Accident. | NaN | CA-210 W | R | Highland | San Bernardino | CA | 92346 | US | US/Pacific | KSBD | 2019-08-23 20:50:00 | 79.0 | 79.0 | 47.0 | 28.63 | 7.0 | SW | 7.0 | 0.0 | Fair | False | False | False | False | False | False | False | False | False | False | False | False | False | Day | Day | Day | Day | Accident | Accident | 2019-08-23 |